APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on DUAL

Line 55: from dual

51: -- 'IP' - In Process when a batch is in process
52:
53: CURSOR C_check_batch_for_all IS
54: select 1
55: from dual
56: where exists ( select 'x'
57: from fa_mass_update_batch_headers
58: where status_code IN ('P', 'E', 'R', 'N', 'IP')
59: and book_type_code = x_book_type_code

Line 66: from dual

62:
63:
64: CURSOR C_check_batch_headers IS
65: select 1
66: from dual
67: where exists ( select 'x'
68: from fa_mass_update_batch_headers hdr
69: where hdr.status_code IN ('P', 'E', 'R', 'N', 'IP')
70: and hdr.book_type_code = x_book_type_code

Line 99: from dual

95: );
96:
97: CURSOR C_check_batch_for_addition IS
98: select 1
99: from dual
100: where exists ( select 'x'
101: from fa_mass_update_batch_headers a
102: where a.status_code IN ('P', 'E', 'R', 'N', 'IP')
103: and a.book_type_code = x_book_type_code

Line 111: from dual

107: 'CHANGE_CATEGORY_LIFE_END_DATE') );
108:
109: CURSOR C_check_batch_for_ata IS
110: select 1
111: from dual
112: where exists ( select 'x'
113: from fa_mass_update_batch_headers a
114: where a.status_code IN ('P', 'E', 'R', 'N', 'IP')
115: and a.book_type_code = x_book_type_code

Line 128: from dual

124: ) );
125:
126: CURSOR C_check_batch_for_transfers IS
127: select 1
128: from dual
129: where exists ( select 'x'
130: from fa_mass_update_batch_headers a
131: where a.status_code IN ('P', 'E', 'R', 'N', 'IP')
132: and a.book_type_code = x_book_type_code

Line 145: from dual

141:
142: /*
143: CURSOR C_check_batch IS
144: select 1
145: from dual
146: where exists ( select 'x'
147: from fa_mass_update_batch_headers a
148: where a.status_code IN ('P', 'R')
149: AND EXISTS ( select 'x'

Line 168: from dual

164: **/
165:
166: CURSOR C_check_hr_retirement IS
167: select 1
168: from dual
169: where exists ( select 'X'
170: from fa_hr_retirement_details
171: -- where status_code = 'P' -- msiddiqu 15-feb-2001
172: where status_code IN ('P', 'IP')

Line 298: from dual

294: IF (x_attribute is null) THEN
295:
296: select 1
297: into v_dummy
298: from dual
299: where exists
300: (
301: select 'X'
302: from fa_mass_update_batch_headers a,

Line 317: from dual

313: ELSIF (x_attribute = 'ASSET_KEY') THEN
314:
315: select 1
316: into v_dummy
317: from dual
318: where exists
319: (
320: select 'X'
321: from fa_mass_update_batch_headers a,

Line 338: from dual

334: ELSIF (x_attribute = 'DISTRIBUTION') THEN
335:
336: select 1
337: into v_dummy
338: from dual
339: where exists
340: (
341: select 'X'
342: from fa_mass_update_batch_headers a,

Line 357: from dual

353: ELSIF (x_attribute = 'LEASE_NUMBER') THEN
354:
355: select 1
356: into v_dummy
357: from dual
358: where exists
359: (
360: select 'X'
361: from fa_mass_update_batch_headers a,

Line 377: from dual

373: ELSIF (x_attribute = 'LIFE_END_DATE') THEN
374:
375: select 1
376: into v_dummy
377: from dual
378: where exists
379: (
380: select 'X'
381: from fa_mass_update_batch_headers a,

Line 397: from dual

393: ELSIF (x_attribute = 'CATEGORY') THEN
394:
395: select 1
396: into v_dummy
397: from dual
398: where exists
399: (
400: select 'X'
401: from fa_mass_update_batch_headers a,

Line 524: from dual;

520: , x_err_stack IN OUT NOCOPY VARCHAR2 ) IS
521:
522: CURSOR C1 IS
523: select fa_hr_retirement_hdrs_s.nextval
524: from dual;
525: v_old_err_stack VARCHAR2(640);
526: BEGIN
527: x_err_code:= '0';
528: v_old_err_stack := x_err_stack;