DBA Data[Home] [Help]

APPS.PAY_KR_WG_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 281: ,pay_run_result_values prrv

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

Line 313: ,pay_run_result_values prrv

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

Line 339: ,pay_run_result_values prrv

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

Line 340: ,pay_run_result_values prrv1

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