APPS.FA_CUA_HR_REINSTATEMENTS_PKG dependencies on FA_HR_RETIREMENT_DETAILS

Line 128: fa_hr_retirement_details ihrd

124: ret.unrevalued_cost_retired,
125: ret.book_type_code,
126: ihrd.current_cost
127: FROM fa_retirements ret,
128: fa_hr_retirement_details ihrd
129: WHERE ihrd.batch_id = x_batch_num
130: AND ret.retirement_id = ihrd.retirement_id
131: AND ret.transaction_header_id_out IS NULL
132: 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;