APPS.HRFASTANSWERS dependencies on PER_BUSINESS_GROUPS

Line 1603: ,per_business_groups bg

1599: cursor c_get_loc_bus is
1600: select bg.location_id
1601: ,loc.country
1602: from hr_locations loc
1603: ,per_business_groups bg
1604: where bg.business_group_id = p_business_group_id
1605: and bg.location_id = loc.location_id;
1606:
1607: l_country hr_locations.country%type;

Line 1710: ' , per_business_groups bgr' ||

1706: open ref_csr for
1707: 'select loc.' || g_region_segment ||
1708: ' ,loc.location_id' ||
1709: ' from hr_locations loc' ||
1710: ' , per_business_groups bgr' ||
1711: ' where loc.location_id = bgr.location_id' ||
1712: ' and bgr.organization_id = :p_business_group_id'
1713: using p_business_group_id;
1714:

Line 1802: , per_business_groups bgr

1798: cursor get_area_bus is
1799: select ter.parent_territory_code
1800: from bis_territory_hierarchies_v ter
1801: , hr_locations loc
1802: , per_business_groups bgr
1803: where ter.child_territory_code = loc.country
1804: and ter.parent_territory_type = 'AREA'
1805: and bgr.location_id = loc.location_id
1806: and bgr.business_group_id = p_business_group_id;

Line 1834: , per_business_groups bgr

1830: -- Then look at the location on the business group
1831: cursor get_country_bus is
1832: select loc.country
1833: from hr_locations loc
1834: , per_business_groups bgr
1835: where loc.location_id = bgr.location_id
1836: and bgr.business_group_id = p_business_group_id;
1837:
1838: l_geog varchar2(2000);

Line 1969: ' , per_business_groups bgr'||

1965:
1966: open reg_cv for
1967: 'select loc.'||g_region_segment||
1968: ' from hr_locations loc'||
1969: ' , per_business_groups bgr'||
1970: ' where loc.location_id = bgr.location_id'||
1971: ' and bgr.organization_id = :p_business_group_id'
1972: using p_business_group_id;
1973: