DBA Data[Home] [Help]

APPS.PAY_GENERIC_UPGRADE dependencies on PER_ALL_PEOPLE_F

Line 602: from per_all_people_f ppf,

598: cp_endperson number
599: ) is
600: select /*+ INDEX(ppf PER_PEOPLE_F_PK)*/
601: distinct ppf.person_id
602: from per_all_people_f ppf,
603: pay_payroll_actions ppa
604: where ppa.payroll_action_id = cp_pactid
605: and ppa.business_group_id = ppf.business_group_id
606: and ppf.person_id between cp_stperson and cp_endperson;

Line 652: from per_all_people_f ppf,

648: cp_endperson number
649: ) is
650: select /*+ INDEX(ppf PER_PEOPLE_F_PK)*/
651: distinct ppf.person_id
652: from per_all_people_f ppf,
653: pay_payroll_actions ppa,
654: per_business_groups_perf pbg,
655: per_business_groups_perf pbg1
656: where ppa.payroll_action_id = cp_pactid

Line 702: from per_all_people_f ppf

698: cp_endperson number
699: ) is
700: select /*+ INDEX(ppf PER_PEOPLE_F_PK)*/
701: distinct ppf.person_id
702: from per_all_people_f ppf
703: where ppf.person_id between cp_stperson and cp_endperson;
704: --
705: cursor c_glo_asg (
706: cp_stperson number,