[Home] [Help]
527: pay_payroll_actions ppa,
528: pay_payroll_actions ppa1,
529: pay_assignment_actions paa,
530: hr_organization_units hou,
531: per_periods_of_service pps
532: where ppa.payroll_action_id = c_payroll_action_id
533: and paa.assignment_id = paaf.assignment_id
534: and pap.person_id between c_start_person and c_end_person
535: and pap.person_id = paaf.person_id
580: pay_payroll_actions ppa,
581: pay_payroll_actions ppa1,
582: pay_assignment_actions paa,
583: hr_organization_units hou,
584: per_periods_of_service pps
585: where ppa.payroll_action_id = c_payroll_action_id
586: and paa.assignment_id = paaf.assignment_id
587: and pap.person_id between c_start_person and c_end_person
588: and pap.person_id = paaf.person_id
633: pay_payroll_actions ppa,
634: pay_payroll_actions ppa1,
635: pay_assignment_actions paa,
636: pay_assignment_actions paa2, /*Bug# 3935471*/
637: per_periods_of_service pps
638: where ppa.payroll_action_id = c_payroll_action_id
639: and paa.assignment_id = paaf.assignment_id /*Bug# 3935471*/
640: AND paa2.assignment_id = paa.assignment_id
641: and pap.person_id between c_start_person and c_end_person
692: pay_payroll_actions ppa,
693: pay_payroll_actions ppa1,
694: pay_assignment_actions paa,
695: pay_assignment_actions paa2, /*Bug# 3935471*/
696: per_periods_of_service pps
697: where ppa.payroll_action_id = c_payroll_action_id
698: and paa.assignment_id = paaf.assignment_id
699: AND paa2.assignment_id = paa.assignment_id /*Bug# 3935471*/
700: and pap.person_id between c_start_person and c_end_person
740: per_assignments_f paaf,
741: pay_payroll_actions ppa,
742: pay_payroll_actions ppa1,
743: pay_assignment_actions paa,
744: per_periods_of_service pps
745: where ppa.payroll_action_id = c_payroll_action_id
746: and paa.assignment_id = paaf.assignment_id
747: and pap.person_id between c_start_person and c_end_person
748: and pap.person_id = paaf.person_id
790: per_assignments_f paaf,
791: pay_payroll_actions ppa,
792: pay_payroll_actions ppa1,
793: pay_assignment_actions paa,
794: per_periods_of_service pps
795: where ppa.payroll_action_id = c_payroll_action_id
796: and paa.assignment_id = paaf.assignment_id
797: and pap.person_id between c_start_person and c_end_person
798: and pap.person_id = paaf.person_id
836: per_assignments_f paaf,
837: pay_payroll_actions ppa,
838: pay_payroll_actions ppa1,
839: pay_assignment_actions paa,
840: per_periods_of_service pps
841: where ppa.payroll_action_id = c_payroll_action_id
842: and paa.assignment_id = paaf.assignment_id
843: and pap.person_id between c_start_person and c_end_person
844: and pap.person_id = paaf.person_id
885: per_assignments_f paaf,
886: pay_payroll_actions ppa,
887: pay_payroll_actions ppa1,
888: pay_assignment_actions paa,
889: per_periods_of_service pps
890: where ppa.payroll_action_id = c_payroll_action_id
891: and paa.assignment_id = paaf.assignment_id
892: and pap.person_id between c_start_person and c_end_person
893: and pap.person_id = paaf.person_id
929: per_assignments_f paaf,
930: pay_payroll_actions ppa,
931: pay_payroll_actions ppa1,
932: pay_assignment_actions paa,
933: per_periods_of_service pps
934: where ppa.payroll_action_id = c_payroll_action_id
935: and paa.assignment_id = paaf.assignment_id
936: and pap.person_id between c_start_person and c_end_person
937: and pap.person_id = paaf.person_id
976: per_assignments_f paaf,
977: pay_payroll_actions ppa,
978: pay_payroll_actions ppa1,
979: pay_assignment_actions paa,
980: per_periods_of_service pps
981: where ppa.payroll_action_id = c_payroll_action_id
982: and paa.assignment_id = paaf.assignment_id
983: and pap.person_id between c_start_person and c_end_person
984: and pap.person_id = paaf.person_id