APPS.HRFASTANSWERS dependencies on PER_POSITIONS

Line 1587: ,per_positions pos

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:
1591: cursor c_get_loc_org is

Line 1679: ' , per_positions pos' ||

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

Line 1776: , per_positions pos

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'
1780: and pos.location_id = loc.location_id

Line 1818: , per_positions pos

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:
1822: -- Then look at the location on the organization

Line 1935: ' , per_positions pos'||

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