APPS.PAY_CA_EOY_ARCHIVE dependencies on PAY_ACTION_CLASSIFICATIONS

Line 686: pay_action_classifications pac

682: paa.assignment_action_id
683: from per_all_assignments_f paf,
684: pay_assignment_actions paa,
685: pay_payroll_actions ppa,
686: pay_action_classifications pac
687: where paf.person_id = p_person_id
688: and paa.assignment_id = paf.assignment_id
689: and paa.tax_unit_id = l_tax_unit_id
690: and paa.payroll_action_id = ppa.payroll_action_id

Line 712: pay_action_classifications pac

708: select paa.assignment_action_id
709: from pay_assignment_actions paa,
710: per_all_assignments_f paf,
711: pay_payroll_actions ppa,
712: pay_action_classifications pac
713: where paf.person_id = p_person_id
714: and paa.assignment_id = paf.assignment_id
715: and paa.tax_unit_id = l_tax_unit_id
716: and paa.payroll_action_id = ppa.payroll_action_id

Line 2183: pay_action_classifications pac,

2179: ppa.date_earned
2180: from per_all_assignments_f paf,
2181: pay_assignment_actions paa,
2182: pay_payroll_actions ppa,
2183: pay_action_classifications pac,
2184: pay_action_contexts pac1,
2185: ff_contexts fc
2186: where paf.person_id = p_person_id
2187: and paa.assignment_id = paf.assignment_id

Line 2220: pay_action_classifications pac,

2216: from pay_assignment_actions paa,
2217: per_all_assignments_f paf,
2218: per_all_people_f ppf,
2219: pay_payroll_actions ppa,
2220: pay_action_classifications pac,
2221: pay_action_contexts pac1,
2222: ff_contexts fc
2223: where ppf.person_id = cp_person_id
2224: and paf.person_id = ppf.person_id

Line 2397: FROM pay_action_classifications pac,

2393: paa1.assignment_id = paf2.assignment_id
2394: and paa1.tax_unit_id = l_tax_unit_id
2395: and (paa1.action_sequence , paf2.person_id) =
2396: (SELECT MAX(paa.action_sequence), paf.person_id
2397: FROM pay_action_classifications pac,
2398: pay_payroll_actions ppa,
2399: pay_assignment_actions paa,
2400: per_all_assignments_f paf1,
2401: per_all_assignments_f paf