VIEW: APPS.PAY_HK_IR56_QUARTERS_INFO_V

Source

View Text - Preformatted

SELECT paei.rowid row_id, paei.assignment_id assignment_id, phiqa.assignment_action_id assignment_action_id, phiqa.action_sequence action_sequence, phiqa.legal_employer_id legal_employer_id, phiqa.l_source_id source_id, paei.aei_information1 quarters_address, hl.meaning quarters_nature, to_char( pay_hk_ir56.get_quarters_start_date(paa.assignment_id,phiqa.l_source_id), 'DD/MM/YYYY') quarters_period_start, to_char(phiqa.end_date, 'DD/MM/YYYY') quarters_period_end, pay_balance_pkg.get_value( pay_hk_soe_pkg.get_balance_id('IR56_Q_ER_TO_LANDLORD','_ASG_SRCE_YTD'), phiqa.assignment_action_id, phiqa.legal_employer_id, null, phiqa.l_source_id, null, null) quarters_er_to_landlord, pay_balance_pkg.get_value( pay_hk_soe_pkg.get_balance_id('IR56_Q_EE_TO_LANDLORD', '_ASG_SRCE_YTD'), phiqa.assignment_action_id, phiqa.legal_employer_id, null, phiqa.l_source_id, null, null) quarters_ee_to_landlord, pay_balance_pkg.get_value( pay_hk_soe_pkg.get_balance_id('IR56_Q_REFUNDS_TO_EE', '_ASG_SRCE_YTD'), phiqa.assignment_action_id, phiqa.legal_employer_id, null, phiqa.l_source_id, null, null) quarters_refunds_to_ee, pay_balance_pkg.get_value( pay_hk_soe_pkg.get_balance_id('IR56_Q_EE_TO_ER', '_ASG_SRCE_YTD'), phiqa.assignment_action_id, phiqa.legal_employer_id, null, phiqa.l_source_id, null, null) quarters_ee_to_er, ptp.start_date, ptp.end_date from per_assignment_extra_info paei, pay_assignment_actions paa, pay_payroll_actions ppa, per_time_periods ptp, pay_hk_ir56_quarters_actions_v phiqa, hr_lookups hl WHERE phiqa.assignment_extra_info_id = paei.assignment_extra_info_id and hl.lookup_type(+) = 'HK_NATURE_OF_QUARTERS' and hl.lookup_code(+) = paei.aei_information2 and paei.assignment_id = paa.assignment_id and phiqa.action_sequence = paa.action_sequence and phiqa.assignment_action_id = paa.assignment_action_id and paa.payroll_action_id = ppa.payroll_action_id and ppa.time_period_id = ptp.time_period_id and ppa.payroll_id = ptp.payroll_id

View Text - HTML Formatted

SELECT PAEI.ROWID ROW_ID
, PAEI.ASSIGNMENT_ID ASSIGNMENT_ID
, PHIQA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PHIQA.ACTION_SEQUENCE ACTION_SEQUENCE
, PHIQA.LEGAL_EMPLOYER_ID LEGAL_EMPLOYER_ID
, PHIQA.L_SOURCE_ID SOURCE_ID
, PAEI.AEI_INFORMATION1 QUARTERS_ADDRESS
, HL.MEANING QUARTERS_NATURE
, TO_CHAR( PAY_HK_IR56.GET_QUARTERS_START_DATE(PAA.ASSIGNMENT_ID
, PHIQA.L_SOURCE_ID)
, 'DD/MM/YYYY') QUARTERS_PERIOD_START
, TO_CHAR(PHIQA.END_DATE
, 'DD/MM/YYYY') QUARTERS_PERIOD_END
, PAY_BALANCE_PKG.GET_VALUE( PAY_HK_SOE_PKG.GET_BALANCE_ID('IR56_Q_ER_TO_LANDLORD'
, '_ASG_SRCE_YTD')
, PHIQA.ASSIGNMENT_ACTION_ID
, PHIQA.LEGAL_EMPLOYER_ID
, NULL
, PHIQA.L_SOURCE_ID
, NULL
, NULL) QUARTERS_ER_TO_LANDLORD
, PAY_BALANCE_PKG.GET_VALUE( PAY_HK_SOE_PKG.GET_BALANCE_ID('IR56_Q_EE_TO_LANDLORD'
, '_ASG_SRCE_YTD')
, PHIQA.ASSIGNMENT_ACTION_ID
, PHIQA.LEGAL_EMPLOYER_ID
, NULL
, PHIQA.L_SOURCE_ID
, NULL
, NULL) QUARTERS_EE_TO_LANDLORD
, PAY_BALANCE_PKG.GET_VALUE( PAY_HK_SOE_PKG.GET_BALANCE_ID('IR56_Q_REFUNDS_TO_EE'
, '_ASG_SRCE_YTD')
, PHIQA.ASSIGNMENT_ACTION_ID
, PHIQA.LEGAL_EMPLOYER_ID
, NULL
, PHIQA.L_SOURCE_ID
, NULL
, NULL) QUARTERS_REFUNDS_TO_EE
, PAY_BALANCE_PKG.GET_VALUE( PAY_HK_SOE_PKG.GET_BALANCE_ID('IR56_Q_EE_TO_ER'
, '_ASG_SRCE_YTD')
, PHIQA.ASSIGNMENT_ACTION_ID
, PHIQA.LEGAL_EMPLOYER_ID
, NULL
, PHIQA.L_SOURCE_ID
, NULL
, NULL) QUARTERS_EE_TO_ER
, PTP.START_DATE
, PTP.END_DATE
FROM PER_ASSIGNMENT_EXTRA_INFO PAEI
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
, PER_TIME_PERIODS PTP
, PAY_HK_IR56_QUARTERS_ACTIONS_V PHIQA
, HR_LOOKUPS HL
WHERE PHIQA.ASSIGNMENT_EXTRA_INFO_ID = PAEI.ASSIGNMENT_EXTRA_INFO_ID
AND HL.LOOKUP_TYPE(+) = 'HK_NATURE_OF_QUARTERS'
AND HL.LOOKUP_CODE(+) = PAEI.AEI_INFORMATION2
AND PAEI.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PHIQA.ACTION_SEQUENCE = PAA.ACTION_SEQUENCE
AND PHIQA.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PPA.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
AND PPA.PAYROLL_ID = PTP.PAYROLL_ID