DBA Data[Home] [Help]

APPS.HRENTMNT dependencies on PAY_RUN_RESULTS

Line 3662: delete from pay_run_results rr

3658: v_entry.effective_end_date,
3659: p_entries_changed);
3660: --
3661: --
3662: delete from pay_run_results rr
3663: where rr.status not like 'P%'
3664: and rr.source_type = 'E'
3665: and rr.source_id = v_entry.element_entry_id;
3666: --

Line 4015: from pay_run_results rr

4011: /* Bug 7603986. All processed and unprocessed entries are checked for any alternate element links
4012: and ((ee.creator_type in ('F','H')
4013: and not exists
4014: (select null
4015: from pay_run_results rr
4016: where rr.source_id = decode(ee.entry_type,
4017: 'A', decode (p_adjust_ee_source,
4018: 'T', ee.target_entry_id,
4019: ee.element_entry_id),