APPS.PER_POSITIONS_PKG dependencies on DUAL

Line 16: from sys.dual

12: --
13: begin
14: select 'Y'
15: into l_exists
16: from sys.dual
17: where exists (select null
18: from per_pos_structure_elements pse
19: where pse.pos_structure_VERSION_id = X_Pos_Structure_Version_Id
20: and ((pse.subordinate_position_id = X_Position_Id

Line 96: from sys.dual

92: p_delete_row := false;
93: begin
94: select '1'
95: into l_exists
96: from sys.dual
97: where exists (select null
98: from per_ALL_assignments_f a
99: where a.position_id = p_position_id);
100: exception when no_data_found then

Line 114: from sys.dual

110: if p_hr_ins = 'Y' then
111: begin
112: select '1'
113: into l_exists
114: from sys.dual
115: where exists (SELECT NULL
116: FROM PAY_ELEMENT_LINKS_F EL
117: WHERE EL.POSITION_ID = p_position_id);
118: exception when no_data_found then

Line 136: from sys.dual

132:
133: begin
134: select '1'
135: into l_exists
136: from sys.dual
137: where exists(SELECT NULL
138: from PER_BUDGET_ELEMENTS BE
139: where BE.POSITION_ID = p_position_id);
140: exception when no_data_found then

Line 155: from sys.dual

151: l_exists := NULL;
152: begin
153: select '1'
154: into l_exists
155: from sys.dual
156: where exists(SELECT NULL
157: from PER_VACANCIES VAC
158: where VAC.POSITION_ID = p_position_id);
159: exception when no_data_found then

Line 193: from sys.dual

189: if l_pos_structure_element_id is null then
190: begin
191: select '1'
192: into l_exists
193: from sys.dual
194: where exists(SELECT NULL
195: FROM PER_POS_STRUCTURE_ELEMENTS PSE
196: WHERE PSE.PARENT_POSITION_ID = p_position_id
197: OR PSE.SUBORDINATE_POSITION_ID = p_position_id) ;

Line 213: from sys.dual

209:
210: begin
211: select '1'
212: into l_exists
213: from sys.dual
214: where exists(SELECT NULL
215: FROM PER_VALID_GRADES VG1
216: WHERE business_group_id + 0 = p_business_group_id
217: AND VG1.POSITION_ID = p_position_id);

Line 232: from sys.dual

228:
229: begin
230: select '1'
231: into l_exists
232: from sys.dual
233: where exists(select null
234: from per_job_requirements jre1
235: where jre1.position_id = p_position_id);
236: exception when no_data_found then

Line 251: from sys.dual

247:
248: begin
249: select '1'
250: into l_exists
251: from sys.dual
252: where exists(select null
253: from per_job_evaluations jev1
254: where jev1.position_id = p_position_id);
255: exception when no_data_found then

Line 269: from sys.dual

265:
266: begin
267: select '1'
268: into l_exists
269: from sys.dual
270: where exists(select null
271: from per_positions
272: where successor_position_id = p_position_id);
273: exception when no_data_found then

Line 287: from sys.dual

283:
284: begin
285: select '1'
286: into l_exists
287: from sys.dual
288: where exists(select null
289: from per_positions
290: where relief_position_id = p_position_id);
291: exception when no_data_found then

Line 305: from sys.dual

301:
302: begin
303: select '1'
304: into l_exists
305: from sys.dual
306: where exists(select null
307: from per_mm_positions
308: where new_position_id = p_position_id);
309: exception when no_data_found then

Line 326: ||'from sys.dual '

322: --
323: if p_po_ins = 'Y' then
324: begin
325: l_sql_text := 'select null '
326: ||'from sys.dual '
327: ||'where exists( select null '
328: ||' from po_system_parameters '
329: ||' where security_position_structure_id = '
330: ||to_char(p_position_id)

Line 428: CURSOR C2 IS SELECT per_positions_s.nextval FROM sys.dual;

424:
425:
426:
427:
428: CURSOR C2 IS SELECT per_positions_s.nextval FROM sys.dual;
429: BEGIN
430: null;
431: /*
432: if (X_Position_Id is NULL) then