DBA Data[Home] [Help]

APPS.HR_DEI_BUS dependencies on PER_ALL_PEOPLE_F

Line 33: , per_all_people_f ppf

29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: , hr_document_extra_info dei
33: , per_all_people_f ppf
34: where dei.document_extra_info_id = p_document_extra_info_id
35: and ppf.person_id = dei.person_id
36: and pbg.business_group_id = ppf.business_group_id;
37: --

Line 105: , per_all_people_f ppf

101: cursor csr_leg_code is
102: select pbg.legislation_code
103: from per_business_groups_perf pbg
104: , hr_document_extra_info dei
105: , per_all_people_f ppf
106: where dei.document_extra_info_id = p_document_extra_info_id
107: and ppf.person_id = dei.person_id
108: and pbg.business_group_id = ppf.business_group_id;
109: --

Line 176: , per_all_people_f ppf

172: --
173: cursor csr_leg_code is
174: select pbg.legislation_code
175: from per_business_groups_perf pbg
176: , per_all_people_f ppf
177: where ppf.person_id = p_person_id
178: and pbg.business_group_id = ppf.business_group_id;
179: --
180: -- Declare local variables