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 1672: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) date tracked position requirement

1668: l_position_id per_all_assignments_f.position_id%TYPE;
1669: l_pos_bus_group_id per_all_assignments_f.business_group_id%TYPE;
1670: l_vac_position_id per_all_assignments_f.position_id%TYPE;
1671: --
1672: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) date tracked position requirement
1673:
1674: cursor csr_valid_pos is
1675: select hp.business_group_id
1676: from hr_positions_f hp

Line 1676: from hr_positions_f hp

1672: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) date tracked position requirement
1673:
1674: cursor csr_valid_pos is
1675: select hp.business_group_id
1676: from hr_positions_f hp
1677: , per_shared_types ps
1678: where hp.position_id = p_position_id
1679: and p_validation_start_date
1680: between hp.effective_start_date

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

1925: l_proc varchar2(72) := g_package||'chk_position_id_org_id';
1926: l_exists varchar2(1);
1927: l_api_updating boolean;
1928: --
1929: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked position requirement
1930: --
1931:
1932: cursor csr_valid_pos_org_comb is
1933: select null

Line 1934: from hr_positions_f hp

1930: --
1931:
1932: cursor csr_valid_pos_org_comb is
1933: select null
1934: from hr_positions_f hp
1935: , per_shared_types ps
1936: where hp.position_id = p_position_id
1937: and p_validation_start_date
1938: between hp.effective_start_date

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

2046: l_proc varchar2(72) := g_package||'chk_position_id_job_id';
2047: l_exists varchar2(1);
2048: l_api_updating boolean;
2049: --
2050: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked position requirement
2051: --
2052: cursor csr_valid_pos_job_comb is
2053: select null
2054: from hr_positions_f hp

Line 2054: from hr_positions_f hp

2050: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked position requirement
2051: --
2052: cursor csr_valid_pos_job_comb is
2053: select null
2054: from hr_positions_f hp
2055: , per_shared_types ps
2056: where hp.position_id = p_position_id
2057: and p_validation_start_date
2058: between hp.effective_start_date