PAY IR56B Control Listing

➜ Back to Library
Description
Categories: BI Publisher
Application: Payroll
Source: IR56B Control Listing Report (XML)
Short Name: PAYHKCTL_XML
DB package: PAY_PAYHKCTL_XMLP_PKG 
select phia.x_hk_employer_tfn,
          phia.x_hk_employer_name,
          phia.x_hk_reporting_year,
          to_number(phia.x_hk_reporting_year)-1 x_hk_reporting_year_l,
          phia.x_hk_last_name||' '||phia.x_hk_other_names Name,
          phia.x_hk_last_name Lname,
          phia.x_hk_other_names Oname,
          phia.x_hk_hkid  x_hk_hkid,
          to_char(phia.x_hk_sheet_no, '099999') x_hk_sheet_no,
          phia.x_hk_contact,
          phia.x_hk_designation,
          phia.x_hk_archive_message,
          decode(phia.x_hk_archive_message,NULL,0,1) Flag,
          decode(phia.x_hk_archive_message,NULL,0,1) GroupFlag,
          decode(phia.x_hk_archive_message,NULL,1,0) Ctr,
          NVL(phia.X_HK_IR56_A_ASG_LE_YTD,0)  X_HK_IR56_A_ASG_LE_YTD,
          NVL(phia.X_HK_IR56_B_ASG_LE_YTD,0)  X_HK_IR56_B_ASG_LE_YTD,
          NVL(phia.X_HK_IR56_C_ASG_LE_YTD,0)   X_HK_IR56_C_ASG_LE_YTD,
          NVL(phia.X_HK_IR56_D_ASG_LE_YTD,0)  X_HK_IR56_D_ASG_LE_YTD,
          NVL(phia.X_HK_IR56_E_ASG_LE_YTD,0)  X_HK_IR56_E_ASG_LE_YTD,
          NVL(phia.X_HK_IR56_F_ASG_LE_YTD,0)  X_HK_IR56_F_ASG_LE_YTD,
          NVL(phia.X_HK_IR56_G_ASG_LE_YTD,0)  X_HK_IR56_G_ASG_LE_YTD,
          NVL(phia.X_HK_IR56_H_ASG_LE_YTD,0)  X_HK_IR56_H_ASG_LE_YTD,
          NVL(phia.X_HK_IR56_I_ASG_LE_YTD,0)  X_HK_IR56_I_ASG_LE_YTD,
          NVL(phia.X_HK_IR56_J_ASG_LE_YTD,0)  X_HK_IR56_J_ASG_LE_YTD,
          NVL(phia.X_HK_IR56_K1_ASG_LE_YTD,0)  X_HK_IR56_K1_ASG_LE_YTD,
          NVL(phia.X_HK_IR56_K2_ASG_LE_YTD,0)  X_HK_IR56_K2_ASG_LE_YTD,
          NVL(phia.X_HK_IR56_K3_ASG_LE_YTD,0)  X_HK_IR56_K3_ASG_LE_YTD,
          NVL(phia.X_HK_IR56_L_ASG_LE_YTD,0)  X_HK_IR56_L_ASG_LE_YTD,
	PAY_PAYHKCTL_XMLP_PKG.cf_balance_calculationformula(decode ( phia.x_hk_archive_message , NULL , 1 , 0 ), NVL ( phia.X_HK_IR56_A_ASG_LE_YTD , 0 ), NVL ( phia.X_HK_IR56_B_ASG_LE_YTD , 0 ), NVL ( phia.X_HK_IR56_C_ASG_LE_YTD , 0 ), NVL ( phia.X_HK_IR56_D_ASG_LE_YTD , 0 ), NVL ( phia.X_HK_IR56_E_ASG_LE_YTD , 0 ), NVL ( phia.X_HK_IR56_F_ASG_LE_YTD , 0 ), NVL ( phia.X_HK_IR56_G_ASG_LE_YTD , 0 ), NVL ( phia.X_HK_IR56_H_ASG_LE_YTD , 0 ), NVL ( phia.X_HK_IR56_I_ASG_LE_YTD , 0 ), NVL ( phia.X_HK_IR56_J_ASG_LE_YTD , 0 ), NVL ( phia.X_HK_IR56_K1_ASG_LE_YTD , 0 ), NVL ( phia.X_HK_IR56_K2_ASG_LE_YTD , 0 ), NVL ( phia.X_HK_IR56_K3_ASG_LE_YTD , 0 ), NVL ( phia.X_HK_IR56_L_ASG_LE_YTD , 0 )) CF_Balance_Calculation
from
pay_hk_ir56_archives_v phia
where
--phia.archive_action_id = :P_ARCHIVE_ACTION_ID
phia.archive_action_id = :LP_ARCHIVE_ACTION_ID
and phia.x_hk_last_name is not null
order by  flag , groupflag, Lname,Oname
Download
Related Blitz Reports
PAY Pay Advice (Hong Kong) PAY MPF Remittance PER Employee listing (Hong Kong) AR Aggregate VAT Statement HXT Location Variance Calculation HXT Earning Variance Calculation PA Process Payroll Actuals AR Customers and Sites PAY IE Cheque Listing
Blitz Report™

Blitz Report™ provides multiple benefits: