APPS.PER_ADDRESSES_PKG dependencies on PER_BUSINESS_GROUPS

Line 353: per_business_groups pbg

349: /*CURSOR get_install_info IS
350: SELECT fpi.status
351: FROM fnd_product_installations fpi,
352: per_people_f ppf,
353: per_business_groups pbg
354: WHERE fpi.application_id = 801
355: AND p_person_id = ppf.person_id
356: AND p_business_group_id = pbg.business_group_id
357: AND pbg.legislation_code = 'US'

Line 370: from per_business_groups pbg

366: 'US' - mmukherj */
367:
368: CURSOR get_legislation_code IS
369: SELECT pbg.legislation_code
370: from per_business_groups pbg
371: where p_business_group_id = pbg.business_group_id;
372:
373: --
374: l_status VARCHAR2(50);

Line 1055: per_business_groups pbg

1051: CURSOR get_install_info IS
1052: SELECT fpi.status
1053: FROM fnd_product_installations fpi,
1054: per_people_f ppf,
1055: per_business_groups pbg
1056: WHERE fpi.application_id = 801
1057: AND p_person_id = ppf.person_id
1058: AND ppf.current_employee_flag = 'Y'
1059: AND p_business_group_id = pbg.business_group_id

Line 1070: from per_business_groups pbg

1066: 'US' - mmukherj */
1067: --
1068: CURSOR get_legislation_code IS
1069: SELECT pbg.legislation_code
1070: from per_business_groups pbg
1071: where p_business_group_id = pbg.business_group_id;
1072: --
1073: l_status VARCHAR2(50);
1074: l_person_type VARCHAR2(50);