APPS.PAY_JP_SOE_PKG dependencies on PAY_RUN_RESULTS

Line 90: from pay_run_results prr,

86: select 'N'
87: from dual
88: where exists(
89: select 1
90: from pay_run_results prr,
91: pay_element_entries_f pee,
92: pay_assignment_actions paa
93: where pee.creator_id = p_creator_id
94: and paa.assignment_id = pee.assignment_id

Line 115: from pay_run_results prr,

111: select 'N'
112: from dual
113: where exists(
114: select 1
115: from pay_run_results prr,
116: pay_element_entries_f pee,
117: pay_assignment_actions paa
118: where pee.creator_id = p_creator_id
119: and paa.assignment_id = pee.assignment_id

Line 201: l_result_status PAY_RUN_RESULTS.STATUS%TYPE;

197: -- Even if the entry is deleted, this function returns correct value.
198: -------------------------------------------------------------------------------
199: IS
200: l_entry_processed VARCHAR2(1);
201: l_result_status PAY_RUN_RESULTS.STATUS%TYPE;
202: CURSOR csr_result_status IS
203: select prr.status
204: from pay_payroll_actions ppa,
205: pay_assignment_actions paa,

Line 206: pay_run_results prr

202: CURSOR csr_result_status IS
203: select prr.status
204: from pay_payroll_actions ppa,
205: pay_assignment_actions paa,
206: pay_run_results prr
207: where prr.source_id = p_element_entry_id
208: --
209: -- Necessary to specify source_type because source_type of
210: -- reversal assignment action means source run_result_id.

Line 219: from pay_run_results prr2

215: and ppa.effective_date
216: between p_effective_start_date and p_effective_end_date
217: and not exists(
218: select NULL
219: from pay_run_results prr2
220: where prr2.source_id = prr.run_result_id
221: and prr2.source_type = 'R')
222: order by decode(prr.status,'U',1,2);
223: BEGIN