DBA Data[Home] [Help]

APPS.HR_ENTRY_API dependencies on PAY_RUN_RESULTS

Line 8056: from pay_run_results

8052: begin
8053: /*
8054: select 'Y'
8055: into l_processed
8056: from pay_run_results
8057: where source_id = p_element_entry_id
8058: and source_type in ('E', 'I')
8059: and status <> 'U';
8060: */

Line 8067: FROM PAY_RUN_RESULTS

8063: INTO l_processed
8064: FROM DUAL
8065: WHERE EXISTS
8066: (SELECT null
8067: FROM PAY_RUN_RESULTS
8068: WHERE source_id = decode(v_entry_rec.entry_type,
8069: 'A', decode (adjust_ee_source,
8070: 'T', v_entry_rec.target_entry_id,
8071: p_element_entry_id),

Line 8393: from pay_run_results prr,

8389: -- Define how to determine if the entry is processed
8390: --
8391: cursor nonrecurring_entries (adjust_ee_source in varchar2) is
8392: select 'Y'
8393: from pay_run_results prr,
8394: pay_element_entries_f pee
8395: where pee.element_entry_id = p_element_entry_id
8396: /* Added the following condition for bug: 7344563 */
8397: and pee.element_entry_id = prr.element_entry_id

Line 8415: from pay_run_results RESULT,

8411: --
8412: cursor recurring_entries is
8413: --
8414: select 'Y'
8415: from pay_run_results RESULT,
8416: pay_assignment_actions ASGT_ACTION,
8417: pay_payroll_actions PAY_ACTION,
8418: per_time_periods PERIOD
8419: where result.source_id = nvl (p_original_entry_id,