547: cp_endperson number
548: ) is
549: select /*+ INDEX(ppf PER_PEOPLE_F_PK)*/
550: distinct ppf.person_id
551: from per_all_people_f ppf,
552: pay_payroll_actions ppa
553: where ppa.payroll_action_id = cp_pactid
554: and ppa.business_group_id = ppf.business_group_id
555: and ppf.person_id between cp_stperson and cp_endperson;
583: cp_endperson number
584: ) is
585: select /*+ INDEX(ppf PER_PEOPLE_F_PK)*/
586: distinct ppf.person_id
587: from per_all_people_f ppf,
588: pay_payroll_actions ppa,
589: per_business_groups_perf pbg,
590: per_business_groups_perf pbg1
591: where ppa.payroll_action_id = cp_pactid
633: cp_endperson number
634: ) is
635: select /*+ INDEX(ppf PER_PEOPLE_F_PK)*/
636: distinct ppf.person_id
637: from per_all_people_f ppf
638: where ppf.person_id between cp_stperson and cp_endperson;
639: --
640: cursor c_glo_asg (
641: cp_stperson number,