DBA Data[Home] [Help]

APPS.PAY_HK_IR56_ARCHIVE dependencies on PAY_HK_IR56_QUARTERS_INFO_V

Line 1082: FROM pay_hk_ir56_quarters_info_v b,

1078: max(b.QUARTERS_ER_TO_LANDLORD) QUARTERS_ER_TO_LANDLORD,
1079: max(b.QUARTERS_EE_TO_LANDLORD) QUARTERS_EE_TO_LANDLORD,
1080: max(b.QUARTERS_REFUND_TO_EE) QUARTERS_REFUND_TO_EE,
1081: max(b.QUARTERS_EE_TO_ER) QUARTERS_EE_TO_ER
1082: FROM pay_hk_ir56_quarters_info_v b,
1083: per_periods_of_service pps,
1084: per_assignments_f paa
1085: WHERE b.assignment_id = c_assignment_id
1086: AND paa.assignment_id = b.assignment_id

Line 1090: FROM pay_hk_ir56_quarters_info_v

1086: AND paa.assignment_id = b.assignment_id
1087: AND paa.person_id = pps.person_id
1088: AND paa.period_of_service_id = pps.period_of_service_id /* Bug No : 2824718 */
1089: AND b.action_sequence = (SELECT max(action_sequence)
1090: FROM pay_hk_ir56_quarters_info_v
1091: WHERE assignment_id = b.assignment_id
1092: AND source_id = b.source_id /* Bug No : 2853776 */
1093: AND start_date between
1094: to_date('01/04/'||to_char(to_number(p_reporting_year)-1),'DD/MM/YYYY')