APPS.PER_IN_CON_LEG_HOOK dependencies on PER_BUSINESS_GROUPS

Line 163: FROM per_business_groups pbg,

159: CURSOR c_business_group_check
160: (p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE)IS
161:
162: SELECT pbg.legislation_code
163: FROM per_business_groups pbg,
164: per_contact_relationships pcr
165: WHERE pcr.contact_relationship_id = p_contact_relationship_id
166: AND pcr.business_group_id = pbg.business_group_id;
167:

Line 339: FROM per_business_groups pbg,

335:
336: CURSOR c_business_group_check
337: (p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE)IS
338: SELECT pbg.legislation_code
339: FROM per_business_groups pbg,
340: per_contact_relationships pcr
341: WHERE pcr.contact_relationship_id = p_contact_relationship_id
342: AND pcr.business_group_id = pbg.business_group_id;
343:

Line 503: FROM per_business_groups pbg,

499:
500: CURSOR c_business_group_check
501: (p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE)IS
502: SELECT pbg.legislation_code
503: FROM per_business_groups pbg,
504: per_contact_relationships pcr
505: WHERE pcr.contact_relationship_id = p_contact_relationship_id
506: AND pcr.business_group_id = pbg.business_group_id;
507: