DBA Data[Home] [Help]

APPS.HRENTMNT dependencies on PAY_RUN_RESULTS

Line 3078: delete from pay_run_results rr

3074: v_entry.effective_end_date,
3075: p_entries_changed);
3076: --
3077: --
3078: delete from pay_run_results rr
3079: where rr.status not like 'P%'
3080: and rr.source_type = 'E'
3081: and rr.source_id = v_entry.element_entry_id;
3082: --

Line 3376: from pay_run_results rr

3372: --
3373: and ((ee.creator_type in ('F','H')
3374: and not exists
3375: (select null
3376: from pay_run_results rr
3377: where rr.source_id = decode(ee.entry_type,
3378: 'A', decode (p_adjust_ee_source,
3379: 'T', ee.target_entry_id,
3380: ee.element_entry_id),