APPS.HR_JOB_POS dependencies on HR_ALL_POSITIONS_F

Line 92: -- Do Any rows Exist in HR_ALL_POSITIONS_F.

88: end;
89: end if;
90: --
91: begin
92: -- Do Any rows Exist in HR_ALL_POSITIONS_F.
93: --
94: -- Changed 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date tracked position requirement
95: --
96: hr_utility.set_location('hr_job_pos.hr_jp_predelete',2);

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

90: --
91: begin
92: -- Do Any rows Exist in HR_ALL_POSITIONS_F.
93: --
94: -- Changed 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date tracked position requirement
95: --
96: hr_utility.set_location('hr_job_pos.hr_jp_predelete',2);
97: select '1'
98: into l_test_func

Line 101: from HR_ALL_POSITIONS_F x

97: select '1'
98: into l_test_func
99: from sys.dual
100: where exists ( select 1
101: from HR_ALL_POSITIONS_F x
102: where x.organization_id = p_organization_id);
103: --
104: if SQL%ROWCOUNT >0 THEN
105: hr_utility.set_message(801,'HR_6557_ORG_POSITIONS_EXIST');

Line 134: -- Doing check on HR_ALL_POSITIONS_F.

130: -- Local Storage variable.
131: l_test_func varchar2(60);
132: begin
133: begin
134: -- Doing check on HR_ALL_POSITIONS_F.
135: --
136: -- Changed 02-Oct-99 SCNair (per_positions to HR_ALL_POSITIONS_F) Date tracked position requirement
137: hr_utility.set_location('hr_job_pos.hr_pos_bg_chk',1);
138: select '1'

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

132: begin
133: begin
134: -- Doing check on HR_ALL_POSITIONS_F.
135: --
136: -- Changed 02-Oct-99 SCNair (per_positions to HR_ALL_POSITIONS_F) Date tracked position requirement
137: hr_utility.set_location('hr_job_pos.hr_pos_bg_chk',1);
138: select '1'
139: into l_test_func
140: from sys.dual

Line 142: from HR_ALL_POSITIONS_F x

138: select '1'
139: into l_test_func
140: from sys.dual
141: where exists ( select 1
142: from HR_ALL_POSITIONS_F x
143: where x.ORGANIZATION_ID = p_organization_id);
144: --
145: if SQL%ROWCOUNT >0 THEN
146: hr_utility.set_message(801,'HR_6726_BG_POS_EXIST');