APPS.PQP_ADDRESS_SYNCHRONIZATION dependencies on PER_BUSINESS_GROUPS

Line 23: ,per_business_groups_perf pbg

19: -- Get person party id
20: CURSOR csr_partyid (c_person_id IN Number) IS
21: SELECT ppf.party_id,pbg.legislation_code
22: FROM per_all_people_f ppf
23: ,per_business_groups_perf pbg
24: WHERE ppf.person_id = c_person_id
25: AND pbg.business_group_id = ppf.business_group_id;
26:
27: -- Get the primary address from OSS

Line 45: FROM per_business_groups pbg

41:
42: -- Cursor to get the leg. code
43: CURSOR csr_bg_code (c_bg_grp_id IN Number) IS
44: SELECT pbg.legislation_code
45: FROM per_business_groups pbg
46: WHERE pbg.business_group_id = c_bg_grp_id;
47:
48: -- =============================================================================
49: -- ~ Addr_DDF_Ins: