DBA Data[Home] [Help]

APPS.PAY_HK_IR56_ARCHIVE dependencies on PAY_HK_IR56_QUARTERS_INFO_V

Line 1013: FROM pay_hk_ir56_quarters_info_v b,

1009: max(b.QUARTERS_ER_TO_LANDLORD) QUARTERS_ER_TO_LANDLORD,
1010: max(b.QUARTERS_EE_TO_LANDLORD) QUARTERS_EE_TO_LANDLORD,
1011: max(b.QUARTERS_REFUND_TO_EE) QUARTERS_REFUND_TO_EE,
1012: max(b.QUARTERS_EE_TO_ER) QUARTERS_EE_TO_ER
1013: FROM pay_hk_ir56_quarters_info_v b,
1014: per_periods_of_service pps,
1015: per_assignments_f paa
1016: WHERE b.assignment_id = c_assignment_id
1017: AND paa.assignment_id = b.assignment_id

Line 1021: FROM pay_hk_ir56_quarters_info_v

1017: AND paa.assignment_id = b.assignment_id
1018: AND paa.person_id = pps.person_id
1019: AND paa.period_of_service_id = pps.period_of_service_id /* Bug No : 2824718 */
1020: AND b.action_sequence = (SELECT max(action_sequence)
1021: FROM pay_hk_ir56_quarters_info_v
1022: WHERE assignment_id = b.assignment_id
1023: AND source_id = b.source_id /* Bug No : 2853776 */
1024: AND start_date between
1025: to_date('01/04/'||to_char(to_number(p_reporting_year)-1),'DD/MM/YYYY')