APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on FA_MASS_UPDATE_BATCH_DETAILS

Line 152: from fa_mass_update_batch_details b

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 )
154: AND ( ( (source_entity_key_value = x_node_id AND
155: event_code = 'CHANGE_NODE_ATTRIBUTE')
156: OR (source_attribute_old_id = x_node_id AND

Line 307: fa_mass_update_batch_details b

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
311: and b.status_code in ('P','R') -- uncommented for bugfix 1613882

Line 326: fa_mass_update_batch_details b

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'
330: and a.batch_id = b.batch_id

Line 347: fa_mass_update_batch_details b

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'
351: and a.batch_id = b.batch_id

Line 366: fa_mass_update_batch_details b

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'
370: and a.batch_id = b.batch_id

Line 386: fa_mass_update_batch_details b

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'
390: and a.batch_id = b.batch_id

Line 406: fa_mass_update_batch_details b

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
410: where -- status_code = 'P' -- bugfix 1613882