eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on FA_MASS_UPDATE_BATCH_DETAILS

Line 150: from fa_mass_update_batch_details b

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

Line 303: fa_mass_update_batch_details b

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

Line 322: fa_mass_update_batch_details b

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

Line 343: fa_mass_update_batch_details b

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

Line 362: fa_mass_update_batch_details b

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

Line 382: fa_mass_update_batch_details b

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

Line 402: fa_mass_update_batch_details b

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