DBA Data[Home] [Help]

APPS.HR_ENTRY_API dependencies on PAY_RUN_RESULTS

Line 8040: from pay_run_results

8036: begin
8037: /*
8038: select 'Y'
8039: into l_processed
8040: from pay_run_results
8041: where source_id = p_element_entry_id
8042: and source_type in ('E', 'I')
8043: and status <> 'U';
8044: */

Line 8051: FROM PAY_RUN_RESULTS

8047: INTO l_processed
8048: FROM DUAL
8049: WHERE EXISTS
8050: (SELECT null
8051: FROM PAY_RUN_RESULTS
8052: WHERE source_id = decode(v_entry_rec.entry_type,
8053: 'A', decode (adjust_ee_source,
8054: 'T', v_entry_rec.target_entry_id,
8055: p_element_entry_id),

Line 8376: from pay_run_results prr,

8372: -- Define how to determine if the entry is processed
8373: --
8374: cursor nonrecurring_entries (adjust_ee_source in varchar2) is
8375: select 'Y'
8376: from pay_run_results prr,
8377: pay_element_entries_f pee
8378: where pee.element_entry_id = p_element_entry_id
8379: /* Added the following condition for bug: 7344563 */
8380: and pee.element_entry_id = prr.element_entry_id

Line 8398: from pay_run_results RESULT,

8394: --
8395: cursor recurring_entries is
8396: --
8397: select 'Y'
8398: from pay_run_results RESULT,
8399: pay_assignment_actions ASGT_ACTION,
8400: pay_payroll_actions PAY_ACTION,
8401: per_time_periods PERIOD
8402: where result.source_id = nvl (p_original_entry_id,