eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on PAY_ACTION_CLASSIFICATIONS

Line 718: pay_action_classifications pac2

714: into l_max_aaid
715: from pay_assignment_actions paa1,
716: per_all_assignments_f paf2,
717: pay_payroll_actions ppa2,
718: pay_action_classifications pac2
719: where paf2.person_id = l_person_id
720: and paa1.assignment_id = paf2.assignment_id
721: and paa1.tax_unit_id = l_tax_unit_id
722: and paa1.payroll_action_id = ppa2.payroll_action_id

Line 730: FROM pay_action_classifications pac,

726: and paf2.effective_end_date
727: and ppa2.effective_date between l_period_start and
728: l_period_end
729: and not exists (select ''
730: FROM pay_action_classifications pac,
731: pay_payroll_actions ppa,
732: pay_assignment_actions paa,
733: per_all_assignments_f paf1
734: WHERE paf1.person_id = l_person_id

Line 1965: pay_action_classifications pac

1961: select paa.assignment_action_id
1962: from pay_assignment_actions paa,
1963: per_all_assignments_f paf,
1964: pay_payroll_actions ppa,
1965: pay_action_classifications pac
1966: where paf.person_id = p_person_id
1967: and paa.assignment_id = paf.assignment_id
1968: and paa.tax_unit_id = l_tax_unit_id
1969: and paa.payroll_action_id = ppa.payroll_action_id

Line 2090: FROM pay_action_classifications pac,

2086: where paa1.assignment_id = paf2.assignment_id
2087: and paa1.tax_unit_id = l_tax_unit_id
2088: and (paa1.action_sequence , paf2.person_id) =
2089: (SELECT MAX(paa.action_sequence), paf.person_id
2090: FROM pay_action_classifications pac,
2091: pay_payroll_actions ppa,
2092: pay_assignment_actions paa,
2093: per_all_assignments_f paf1,
2094: per_all_assignments_f paf