DBA Data[Home] [Help]

APPS.PAY_KR_WG_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 287: ,pay_run_result_values prrv

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')
291: and prr.status = 'P'

Line 319: ,pay_run_result_values prrv

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
323: and prr.entry_type IN ('I','E')

Line 345: ,pay_run_result_values prrv

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
349: where paa.assignment_id = p_assignment_id

Line 346: ,pay_run_result_values prrv1

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
349: where paa.assignment_id = p_assignment_id
350: and prr.assignment_action_id = paa.assignment_action_id