158: CURSOR c_business_group_check
159: (p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE)IS
160:
161: SELECT pbg.legislation_code
162: FROM per_business_groups pbg,
163: per_contact_relationships pcr
164: WHERE pcr.contact_relationship_id = p_contact_relationship_id
165: AND pcr.business_group_id = pbg.business_group_id;
166:
333:
334: CURSOR c_business_group_check
335: (p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE)IS
336: SELECT pbg.legislation_code
337: FROM per_business_groups pbg,
338: per_contact_relationships pcr
339: WHERE pcr.contact_relationship_id = p_contact_relationship_id
340: AND pcr.business_group_id = pbg.business_group_id;
341:
497:
498: CURSOR c_business_group_check
499: (p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE)IS
500: SELECT pbg.legislation_code
501: FROM per_business_groups pbg,
502: per_contact_relationships pcr
503: WHERE pcr.contact_relationship_id = p_contact_relationship_id
504: AND pcr.business_group_id = pbg.business_group_id;
505: