APPS.FA_CUA_HR_REINSTATEMENTS_PKG dependencies on FA_HR_RETIREMENT_DETAILS

Line 130: fa_hr_retirement_details ihrd

126: ret.unrevalued_cost_retired,
127: ret.book_type_code,
128: ihrd.current_cost
129: FROM fa_retirements ret,
130: fa_hr_retirement_details ihrd
131: WHERE ihrd.batch_id = x_batch_num
132: AND ret.retirement_id = ihrd.retirement_id
133: AND ret.transaction_header_id_out IS NULL
134: AND ret.date_retired BETWEEN x_fy_Start_Date

Line 254: update fa_hr_retirement_details

250: update fa_hr_retirement_headers
251: set status_code = 'RC' -- reinstatement completed
252: where batch_id = x_batch_num;
253:
254: update fa_hr_retirement_details
255: set status_code = 'RI' -- reinstated
256: where batch_id = x_batch_num;
257:
258: commit;

Line 335: update fa_hr_retirement_details

331: update fa_hr_retirement_headers
332: set status_code = 'RP'
333: where batch_id = hrh_rec.batch_id;
334:
335: update fa_hr_retirement_details
336: set status_code = 'RP'
337: where batch_id = hrh_rec.batch_id;
338:
339: commit;