DBA Data[Home] [Help]

APPS.PAY_MX_YREND_ARCH dependencies on PAY_ACTION_CLASSIFICATIONS

Line 46: pay_action_classifications in

42: - Added missing join condition
43: for effective dates in cursor
44: c_get_ytd_aaid.
45: - Added join with
46: pay_action_classifications in
47: c_get_ytd_aaid.
48: 115.5 18-OCT-2005 ardsouza Modified to store start and end
49: dates instead of months.
50: Collective agreement of all

Line 1470: pay_action_classifications pac

1466: pay_assignment_actions paa_pri,
1467: pay_payroll_actions ppa,
1468: per_assignments_f paf_pri,
1469: per_assignments_f paf_all,
1470: pay_action_classifications pac
1471: WHERE paa_pri.assignment_action_id = p_archive_action_id
1472: AND paf_pri.assignment_id = paa_pri.assignment_id
1473: AND paf_all.period_of_service_id = paf_pri.period_of_service_id
1474: AND paa_all.tax_unit_id = cp_tax_unit_id