APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on FA_MASS_UPDATE_BATCH_HEADERS

Line 57: from fa_mass_update_batch_headers

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
60: and ( x_conc_request_id is null OR
61: nvl(concurrent_request_id,0) <> x_conc_request_id ) );

Line 68: from fa_mass_update_batch_headers hdr

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
71: and ( x_conc_request_id is null OR
72: nvl(hdr.concurrent_request_id,0) <> x_conc_request_id )

Line 101: from fa_mass_update_batch_headers a

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
104: and a.event_code IN ( 'CHANGE_NODE_PARENT', 'CHANGE_NODE_ATTRIBUTE',
105: 'CHANGE_NODE_RULE_SET', 'CHANGE_CATEGORY_RULE_SET',

Line 113: from fa_mass_update_batch_headers a

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
116: and ( a.event_code IN ( 'CHANGE_NODE_PARENT', 'CHANGE_NODE_ATTRIBUTE',
117: 'CHANGE_NODE_RULE_SET', 'CHANGE_CATEGORY_RULE_SET',

Line 130: from fa_mass_update_batch_headers a

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
133: and ( a.event_code IN ( 'CHANGE_NODE_PARENT', 'CHANGE_NODE_ATTRIBUTE',
134: 'CHANGE_NODE_RULE_SET', 'CHANGE_CATEGORY_RULE_SET',

Line 147: from fa_mass_update_batch_headers a

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'
150: from fa_mass_update_batch_details b
151: where a.batch_id = b.batch_id )

Line 302: from fa_mass_update_batch_headers a,

298: from dual
299: where exists
300: (
301: select 'X'
302: from fa_mass_update_batch_headers a,
303: fa_mass_update_batch_details b
304: where a.status_code <> 'C'
305: and a.event_code <> 'HR_REINSTATEMENT' -- bugfix for 891822 msiddiqu 25-APR-2001
306: and a.batch_id = b.batch_id

Line 321: from fa_mass_update_batch_headers a,

317: from dual
318: where exists
319: (
320: select 'X'
321: from fa_mass_update_batch_headers a,
322: fa_mass_update_batch_details b
323: -- where x_attribute IS NOT NULL
324: -- where x_attribute = 'ASSET_KEY'
325: where a.status_code <> 'C'

Line 342: from fa_mass_update_batch_headers a,

338: from dual
339: where exists
340: (
341: select 'X'
342: from fa_mass_update_batch_headers a,
343: fa_mass_update_batch_details b
344: -- where x_attribute IS NOT NULL
345: -- where x_attribute = 'DISTRIBUTION'
346: where a.status_code <> 'C'

Line 361: from fa_mass_update_batch_headers a,

357: from dual
358: where exists
359: (
360: select 'X'
361: from fa_mass_update_batch_headers a,
362: fa_mass_update_batch_details b
363: -- where x_attribute IS NOT NULL
364: -- where x_attribute = 'LEASE_NUMBER'
365: where a.status_code <> 'C'

Line 381: from fa_mass_update_batch_headers a,

377: from dual
378: where exists
379: (
380: select 'X'
381: from fa_mass_update_batch_headers a,
382: fa_mass_update_batch_details b
383: -- where x_attribute IS NOT NULL
384: -- where x_attribute = 'LIFE_END_DATE'
385: where a.status_code <> 'C'

Line 401: from fa_mass_update_batch_headers a,

397: from dual
398: where exists
399: (
400: select 'X'
401: from fa_mass_update_batch_headers a,
402: fa_mass_update_batch_details b
403: -- where x_attribute IS NOT NULL
404: -- where x_attribute = 'CATEGORY'
405: -- if category check for all attributes