[Home] [Help]
341: pay_payroll_actions ppa,
342: pay_payroll_actions ppa1,
343: pay_assignment_actions paa,
344: hr_organization_units hou,
345: per_periods_of_service pps
346: -- ,per_assignment_status_types past
347: where ppa.payroll_action_id = c_payroll_action_id
348: and paa.assignment_id = paaf.assignment_id
349: and pap.person_id between c_start_person and c_end_person
394: pay_payroll_actions ppa,
395: pay_payroll_actions ppa1,
396: pay_assignment_actions paa,
397: hr_organization_units hou,
398: per_periods_of_service pps
399: where ppa.payroll_action_id = c_payroll_action_id
400: and paa.assignment_id = paaf.assignment_id
401: and pap.person_id between c_start_person and c_end_person
402: and pap.person_id = paaf.person_id
440: per_assignments_f paaf,
441: pay_payroll_actions ppa,
442: pay_payroll_actions ppa1,
443: pay_assignment_actions paa,
444: per_periods_of_service pps
445: -- ,per_assignment_status_types past
446: where ppa.payroll_action_id = c_payroll_action_id
447: and paa.assignment_id = paaf.assignment_id
448: and pap.person_id between c_start_person and c_end_person
491: per_assignments_f paaf,
492: pay_payroll_actions ppa,
493: pay_payroll_actions ppa1,
494: pay_assignment_actions paa,
495: per_periods_of_service pps
496: where ppa.payroll_action_id = c_payroll_action_id
497: and paa.assignment_id = paaf.assignment_id
498: and pap.person_id between c_start_person and c_end_person
499: and pap.person_id = paaf.person_id
535: per_assignments_f paaf,
536: pay_payroll_actions ppa,
537: pay_payroll_actions ppa1,
538: pay_assignment_actions paa,
539: per_periods_of_service pps
540: -- per_assignment_status_types past
541: where ppa.payroll_action_id = c_payroll_action_id
542: and paa.assignment_id = paaf.assignment_id
543: and pap.person_id between c_start_person and c_end_person
585: per_assignments_f paaf,
586: pay_payroll_actions ppa,
587: pay_payroll_actions ppa1,
588: pay_assignment_actions paa,
589: per_periods_of_service pps
590: where ppa.payroll_action_id = c_payroll_action_id
591: and paa.assignment_id = paaf.assignment_id
592: and pap.person_id between c_start_person and c_end_person
593: and pap.person_id = paaf.person_id
630: per_assignments_f paaf,
631: pay_payroll_actions ppa,
632: pay_payroll_actions ppa1,
633: pay_assignment_actions paa,
634: per_periods_of_service pps
635: -- ,per_assignment_status_types past
636: where ppa.payroll_action_id = c_payroll_action_id
637: and paa.assignment_id = paaf.assignment_id
638: and pap.person_id between c_start_person and c_end_person
679: per_assignments_f paaf,
680: pay_payroll_actions ppa,
681: pay_payroll_actions ppa1,
682: pay_assignment_actions paa,
683: per_periods_of_service pps
684: where ppa.payroll_action_id = c_payroll_action_id
685: and paa.assignment_id = paaf.assignment_id
686: and pap.person_id between c_start_person and c_end_person
687: and pap.person_id = paaf.person_id
722: per_assignments_f paaf,
723: pay_payroll_actions ppa,
724: pay_payroll_actions ppa1,
725: pay_assignment_actions paa,
726: per_periods_of_service pps
727: -- ,per_assignment_status_types past
728: where ppa.payroll_action_id = c_payroll_action_id
729: and paa.assignment_id = paaf.assignment_id
730: and pap.person_id between c_start_person and c_end_person
769: per_assignments_f paaf,
770: pay_payroll_actions ppa,
771: pay_payroll_actions ppa1,
772: pay_assignment_actions paa,
773: per_periods_of_service pps
774: where ppa.payroll_action_id = c_payroll_action_id
775: and paa.assignment_id = paaf.assignment_id
776: and pap.person_id between c_start_person and c_end_person
777: and pap.person_id = paaf.person_id
1566: hou1.NAME Legal_Employer /*Bug 4132525*/
1567: from per_people_f pap,
1568: per_assignments_f paa,
1569: per_grades_tl pgr, /* Bug 3953702*/
1570: per_periods_of_service pps,
1571: per_pay_bases ppb,
1572: per_pay_proposals pro,
1573: per_assignment_status_types past,
1574: hr_soft_coding_keyflex hsc, /*Bug 4040688*/