eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRFASTANSWERS dependencies on HR_LOCATIONS

Line 1580: from hr_locations

1576: return number is
1577:
1578: cursor location_csr is
1579: select country
1580: from hr_locations
1581: where location_id = p_location_id;
1582:
1583: cursor c_get_loc_pos is
1584: select pos.location_id

Line 1586: from hr_locations loc

1582:
1583: cursor c_get_loc_pos is
1584: select pos.location_id
1585: ,loc.country
1586: from hr_locations loc
1587: ,per_positions pos
1588: where pos.position_id = p_position_id
1589: and pos.location_id = loc.location_id;
1590:

Line 1594: from hr_locations loc

1590:
1591: cursor c_get_loc_org is
1592: select org.location_id
1593: ,loc.country
1594: from hr_locations loc
1595: ,hr_organization_units org
1596: where org.organization_id = p_organization_id
1597: and org.location_id = loc.location_id;
1598:

Line 1602: from hr_locations loc

1598:
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:

Line 1607: l_country hr_locations.country%type;

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;
1608: l_location_id hr_locations.location_id%type;
1609: l_region hr_locations.attribute1%type;
1610:
1611: type RefCursorType is REF CURSOR;

Line 1608: l_location_id hr_locations.location_id%type;

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;
1608: l_location_id hr_locations.location_id%type;
1609: l_region hr_locations.attribute1%type;
1610:
1611: type RefCursorType is REF CURSOR;
1612: ref_csr RefCursorType;

Line 1609: l_region hr_locations.attribute1%type;

1605: and bg.location_id = loc.location_id;
1606:
1607: l_country hr_locations.country%type;
1608: l_location_id hr_locations.location_id%type;
1609: l_region hr_locations.attribute1%type;
1610:
1611: type RefCursorType is REF CURSOR;
1612: ref_csr RefCursorType;
1613:

Line 1661: ' from hr_locations loc' ||

1657: if (p_location_id is not null) then
1658:
1659: open ref_csr for
1660: 'select loc.' || g_region_segment ||
1661: ' from hr_locations loc' ||
1662: ' where loc.location_id = :p_location_id'
1663: using p_location_id;
1664:
1665: fetch ref_csr into l_region;

Line 1678: ' from hr_locations loc' ||

1674:
1675: open ref_csr for
1676: 'select loc.' || g_region_segment ||
1677: ' ,loc.location_id' ||
1678: ' from hr_locations loc' ||
1679: ' , per_positions pos' ||
1680: ' where loc.location_id = pos.location_id' ||
1681: ' and pos.position_id = :p_position_id'
1682: using p_position_id;

Line 1694: ' from hr_locations loc' ||

1690:
1691: open ref_csr for
1692: 'select loc.' || g_region_segment ||
1693: ' ,loc.location_id' ||
1694: ' from hr_locations loc' ||
1695: ' , hr_organization_units hou' ||
1696: ' where loc.location_id = hou.location_id' ||
1697: ' and hou.organization_id = :p_organization_id'
1698: using p_organization_id;

Line 1709: ' from hr_locations loc' ||

1705:
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;

Line 1765: , hr_locations loc

1761: -- to the next level as it's found a record
1762: cursor get_area is
1763: select nvl(ter.parent_territory_code,'Unassigned')
1764: from bis_territory_hierarchies_v ter
1765: , hr_locations loc
1766: where ter.child_territory_code(+) = loc.country
1767: and decode(ter.parent_territory_type,null,'AREA'
1768: ,ter.parent_territory_type) = 'AREA'
1769: and loc.location_id = p_location_id;

Line 1775: , hr_locations loc

1771: -- Then look at location on the position
1772: cursor get_area_pos is
1773: select nvl(ter.parent_territory_code, 'Unassigned')
1774: from bis_territory_hierarchies_v ter
1775: , hr_locations loc
1776: , per_positions pos
1777: where ter.child_territory_code(+) = loc.country
1778: and decode(ter.parent_territory_type,null,'AREA'
1779: ,ter.parent_territory_type) = 'AREA'

Line 1787: , hr_locations loc

1783: -- Then look at location on the organization
1784: cursor get_area_org is
1785: select nvl(ter.parent_territory_code, 'Unassigned')
1786: from bis_territory_hierarchies_v ter
1787: , hr_locations loc
1788: , hr_organization_units hou
1789: where ter.child_territory_code(+) = loc.country
1790: and decode(ter.parent_territory_type,null,'AREA'
1791: ,ter.parent_territory_type) = 'AREA'

Line 1801: , hr_locations loc

1797: -- don't want to drill any further
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

Line 1811: from hr_locations loc

1807:
1808: -- First look at location on the assignment
1809: cursor get_country is
1810: select loc.country
1811: from hr_locations loc
1812: where loc.location_id = p_location_id;
1813:
1814: -- Then look at location on the position
1815: cursor get_country_pos is

Line 1817: from hr_locations loc

1813:
1814: -- Then look at location on the position
1815: cursor get_country_pos is
1816: select loc.country
1817: from hr_locations loc
1818: , per_positions pos
1819: where loc.location_id = pos.location_id
1820: and pos.position_id = p_position_id;
1821:

Line 1825: from hr_locations loc

1821:
1822: -- Then look at the location on the organization
1823: cursor get_country_org is
1824: select loc.country
1825: from hr_locations loc
1826: , hr_organization_units hou
1827: where loc.location_id = hou.location_id
1828: and hou.organization_id = p_organization_id;
1829:

Line 1833: from hr_locations loc

1829:
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:

Line 1920: ' from hr_locations loc'||

1916: -- Build and execute the dynamic sql statement
1917:
1918: open reg_cv for
1919: 'select loc.'||g_region_segment||
1920: ' from hr_locations loc'||
1921: ' where loc.location_id = :p_location_id'
1922: using p_location_id;
1923:
1924: fetch reg_cv into l_geog;

Line 1934: ' from hr_locations loc'||

1930:
1931: close reg_cv;
1932: open reg_cv for
1933: 'select loc.'||g_region_segment||
1934: ' from hr_locations loc'||
1935: ' , per_positions pos'||
1936: ' where loc.location_id = pos.location_id'||
1937: ' and pos.position_id = :p_position_id'
1938: using p_position_id;

Line 1951: ' from hr_locations loc'||

1947: close reg_cv;
1948:
1949: open reg_cv for
1950: 'select loc.'||g_region_segment||
1951: ' from hr_locations loc'||
1952: ' , hr_organization_units hou'||
1953: ' where loc.location_id = hou.location_id'||
1954: ' and hou.organization_id = :p_organization_id'
1955: using p_organization_id;

Line 1968: ' from hr_locations loc'||

1964: close reg_cv;
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;