DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_BUSINESS_GROUPS

Line 23: from per_business_groups x , per_all_people_f papf

19: cursor csr_bg_name
20: (p_person_id number,
21: p_effective_date date) is
22: select x.name
23: from per_business_groups x , per_all_people_f papf
24: where x.business_group_id = papf.business_group_id
25: and papf.person_id=p_person_id;
26: --
27: --Added for PMxbg

Line 31: from per_business_groups x

27: --Added for PMxbg
28: cursor csr_get_leg
29: (p_business_group_id number) is
30: select x.legislation_code
31: from per_business_groups x
32: where x.business_group_id=p_business_group_id;
33: --
34: cursor csr_template(p_legislation_code varchar2) is
35: select