APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on FA_MASS_UPDATE_BATCH_HEADERS

Line 59: from fa_mass_update_batch_headers

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

Line 70: from fa_mass_update_batch_headers hdr

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

Line 103: from fa_mass_update_batch_headers a

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

Line 115: from fa_mass_update_batch_headers a

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

Line 132: from fa_mass_update_batch_headers a

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

Line 149: from fa_mass_update_batch_headers a

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

Line 306: from fa_mass_update_batch_headers a,

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

Line 325: from fa_mass_update_batch_headers a,

321: from dual
322: where exists
323: (
324: select 'X'
325: from fa_mass_update_batch_headers a,
326: fa_mass_update_batch_details b
327: -- where x_attribute IS NOT NULL
328: -- where x_attribute = 'ASSET_KEY'
329: where a.status_code <> 'C'

Line 346: from fa_mass_update_batch_headers a,

342: from dual
343: where exists
344: (
345: select 'X'
346: from fa_mass_update_batch_headers a,
347: fa_mass_update_batch_details b
348: -- where x_attribute IS NOT NULL
349: -- where x_attribute = 'DISTRIBUTION'
350: where a.status_code <> 'C'

Line 365: from fa_mass_update_batch_headers a,

361: from dual
362: where exists
363: (
364: select 'X'
365: from fa_mass_update_batch_headers a,
366: fa_mass_update_batch_details b
367: -- where x_attribute IS NOT NULL
368: -- where x_attribute = 'LEASE_NUMBER'
369: where a.status_code <> 'C'

Line 385: from fa_mass_update_batch_headers a,

381: from dual
382: where exists
383: (
384: select 'X'
385: from fa_mass_update_batch_headers a,
386: fa_mass_update_batch_details b
387: -- where x_attribute IS NOT NULL
388: -- where x_attribute = 'LIFE_END_DATE'
389: where a.status_code <> 'C'

Line 405: from fa_mass_update_batch_headers a,

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