[Home] [Help]
787: paa.assignment_action_id
788: from per_all_assignments_f paf,
789: pay_assignment_actions paa,
790: pay_payroll_actions ppa,
791: pay_action_classifications pac
792: where paf.person_id = p_person_id
793: and paa.assignment_id = paf.assignment_id
794: and paa.tax_unit_id = l_tax_unit_id
795: and paa.payroll_action_id = ppa.payroll_action_id
813: select paa.assignment_action_id
814: from pay_assignment_actions paa,
815: per_all_assignments_f paf,
816: pay_payroll_actions ppa,
817: pay_action_classifications pac
818: where paf.person_id = p_person_id
819: and paa.assignment_id = paf.assignment_id
820: and paa.tax_unit_id = l_tax_unit_id
821: and paa.payroll_action_id = ppa.payroll_action_id
2468: ppa.date_earned
2469: from per_all_assignments_f paf,
2470: pay_assignment_actions paa,
2471: pay_payroll_actions ppa,
2472: pay_action_classifications pac,
2473: pay_action_contexts pac1,
2474: ff_contexts fc
2475: where paf.person_id = p_person_id
2476: and paa.assignment_id = paf.assignment_id
2505: from pay_assignment_actions paa,
2506: per_all_assignments_f paf,
2507: per_all_people_f ppf,
2508: pay_payroll_actions ppa,
2509: pay_action_classifications pac,
2510: pay_action_contexts pac1,
2511: ff_contexts fc
2512: where ppf.person_id = cp_person_id
2513: and paf.person_id = ppf.person_id
2699: paa1.assignment_id = paf2.assignment_id
2700: and paa1.tax_unit_id = l_tax_unit_id
2701: and (paa1.action_sequence , paf2.person_id) =
2702: (SELECT MAX(paa.action_sequence), paf.person_id
2703: FROM pay_action_classifications pac,
2704: pay_payroll_actions ppa,
2705: pay_assignment_actions paa,
2706: per_all_assignments_f paf1,
2707: per_all_assignments_f paf