DBA Data[Home] [Help]

APPS.PAY_PL_PAYE_API dependencies on PER_ALL_PEOPLE_F

Line 33: from per_all_people_f papf,

29: --
30: -- Declare cursors and local variables
31: --
32: cursor cur_prs is select min(papf.effective_start_date)
33: from per_all_people_f papf,
34: per_person_types ppt
35: where papf.person_type_id = ppt.person_type_id
36: and system_person_type in ('EMP','EMP_APL')
37: and papf.person_id = p_per_or_asg_id

Line 899: from per_all_people_f papf

895:
896: cursor csr_get_derived_details is
897: select bus.business_group_id
898: , bus.legislation_code
899: from per_all_people_f papf
900: , per_business_groups_perf bus
901: where papf.person_id = p_person_id
902: and l_effective_date between papf.effective_start_date
903: and papf.effective_end_date