DBA Data[Home] [Help]

APPS.PAY_KR_WG_PKG dependencies on PAY_RUN_RESULTS

Line 280: from pay_run_results prr

276: l_oblig_release_processed VARCHAR2(1) := 'N';
277: --
278: Cursor csr_oblig_release_processed IS
279: SELECT 'Y'
280: from pay_run_results prr
281: ,pay_run_result_values prrv
282: ,pay_input_values_f piv
283: where prr.source_id = p_element_entry_id
284: and prr.entry_type IN ('I','E')

Line 312: from pay_run_results prr

308: IS
309:
310: CURSOR csr_prev_payout IS
311: SELECT fnd_date.canonical_to_date(prrv.result_value)
312: from pay_run_results prr
313: ,pay_run_result_values prrv
314: ,pay_element_types_f pet
315: ,pay_input_values_f piv
316: where prr.source_id = p_element_entry_id

Line 338: ,pay_run_results prr

334: CURSOR csr_prev_payout_bal_adj(p_element_type_id IN NUMBER) IS
335: SELECT fnd_date.canonical_to_date(prrv.result_value)
336: from pay_payroll_actions ppa
337: ,pay_assignment_actions paa
338: ,pay_run_results prr
339: ,pay_run_result_values prrv
340: ,pay_run_result_values prrv1
341: ,pay_input_values_f piv
342: ,pay_input_values_f piv1