APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on DUAL

Line 57: from dual

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

Line 68: from dual

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

Line 101: from dual

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

Line 113: from dual

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

Line 130: from dual

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

Line 147: from dual

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

Line 170: from dual

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

Line 302: from dual

298: IF (x_attribute is null) THEN
299:
300: select 1
301: into v_dummy
302: from dual
303: where exists
304: (
305: select 'X'
306: from fa_mass_update_batch_headers a,

Line 321: from dual

317: ELSIF (x_attribute = 'ASSET_KEY') THEN
318:
319: select 1
320: into v_dummy
321: from dual
322: where exists
323: (
324: select 'X'
325: from fa_mass_update_batch_headers a,

Line 342: from dual

338: ELSIF (x_attribute = 'DISTRIBUTION') THEN
339:
340: select 1
341: into v_dummy
342: from dual
343: where exists
344: (
345: select 'X'
346: from fa_mass_update_batch_headers a,

Line 361: from dual

357: ELSIF (x_attribute = 'LEASE_NUMBER') THEN
358:
359: select 1
360: into v_dummy
361: from dual
362: where exists
363: (
364: select 'X'
365: from fa_mass_update_batch_headers a,

Line 381: from dual

377: ELSIF (x_attribute = 'LIFE_END_DATE') THEN
378:
379: select 1
380: into v_dummy
381: from dual
382: where exists
383: (
384: select 'X'
385: from fa_mass_update_batch_headers a,

Line 401: from dual

397: ELSIF (x_attribute = 'CATEGORY') THEN
398:
399: select 1
400: into v_dummy
401: from dual
402: where exists
403: (
404: select 'X'
405: from fa_mass_update_batch_headers a,

Line 528: from dual;

524: , x_err_stack IN OUT NOCOPY VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
525:
526: CURSOR C1 IS
527: select fa_hr_retirement_hdrs_s.nextval
528: from dual;
529: v_old_err_stack VARCHAR2(640);
530: BEGIN
531: x_err_code:= '0';
532: v_old_err_stack := x_err_stack;