DBA Data[Home] [Help]

APPS.PAY_KR_WG_PKG dependencies on PAY_RUN_RESULTS

Line 286: from pay_run_results prr

282: l_oblig_release_processed VARCHAR2(1) := 'N';
283: --
284: Cursor csr_oblig_release_processed IS
285: SELECT 'Y'
286: from pay_run_results prr
287: ,pay_run_result_values prrv
288: ,pay_input_values_f piv
289: where prr.source_id = p_element_entry_id
290: and prr.entry_type IN ('I','E')

Line 318: from pay_run_results prr

314: IS
315:
316: CURSOR csr_prev_payout IS
317: SELECT fnd_date.canonical_to_date(prrv.result_value)
318: from pay_run_results prr
319: ,pay_run_result_values prrv
320: ,pay_element_types_f pet
321: ,pay_input_values_f piv
322: where prr.source_id = p_element_entry_id

Line 344: ,pay_run_results prr

340: CURSOR csr_prev_payout_bal_adj(p_element_type_id IN NUMBER) IS
341: SELECT fnd_date.canonical_to_date(prrv.result_value)
342: from pay_payroll_actions ppa
343: ,pay_assignment_actions paa
344: ,pay_run_results prr
345: ,pay_run_result_values prrv
346: ,pay_run_result_values prrv1
347: ,pay_input_values_f piv
348: ,pay_input_values_f piv1