DBA Data[Home] [Help]

APPS.HR_DEI_BUS dependencies on PER_BUSINESS_GROUPS_PERF

Line 31: from per_business_groups_perf pbg

27: --
28: cursor csr_sec_grp is
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

Line 103: from per_business_groups_perf pbg

99: -- Declare cursor
100: --
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

Line 175: from per_business_groups_perf pbg

171: -- Declare cursor
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: --