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.PER_ASG_BUS2 dependencies on HR_POSITIONS_F

Line 1632: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) date tracked position requirement

1628: l_position_id per_all_assignments_f.position_id%TYPE;
1629: l_pos_bus_group_id per_all_assignments_f.business_group_id%TYPE;
1630: l_vac_position_id per_all_assignments_f.position_id%TYPE;
1631: --
1632: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) date tracked position requirement
1633:
1634: cursor csr_valid_pos is
1635: select hp.business_group_id
1636: from hr_positions_f hp

Line 1636: from hr_positions_f hp

1632: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) date tracked position requirement
1633:
1634: cursor csr_valid_pos is
1635: select hp.business_group_id
1636: from hr_positions_f hp
1637: , per_shared_types ps
1638: where hp.position_id = p_position_id
1639: and p_validation_start_date
1640: between hp.effective_start_date

Line 1889: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked position requirement

1885: l_proc varchar2(72) := g_package||'chk_position_id_org_id';
1886: l_exists varchar2(1);
1887: l_api_updating boolean;
1888: --
1889: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked position requirement
1890: --
1891:
1892: cursor csr_valid_pos_org_comb is
1893: select null

Line 1894: from hr_positions_f hp

1890: --
1891:
1892: cursor csr_valid_pos_org_comb is
1893: select null
1894: from hr_positions_f hp
1895: , per_shared_types ps
1896: where hp.position_id = p_position_id
1897: and p_validation_start_date
1898: between hp.effective_start_date

Line 2010: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked position requirement

2006: l_proc varchar2(72) := g_package||'chk_position_id_job_id';
2007: l_exists varchar2(1);
2008: l_api_updating boolean;
2009: --
2010: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked position requirement
2011: --
2012: cursor csr_valid_pos_job_comb is
2013: select null
2014: from hr_positions_f hp

Line 2014: from hr_positions_f hp

2010: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked position requirement
2011: --
2012: cursor csr_valid_pos_job_comb is
2013: select null
2014: from hr_positions_f hp
2015: , per_shared_types ps
2016: where hp.position_id = p_position_id
2017: and p_validation_start_date
2018: between hp.effective_start_date