DBA Data[Home] [Help]

APPS.PAY_KR_NONSTAT_SPAY_EFILE_FUN dependencies on PAY_RUN_RESULTS

Line 96: ,pay_run_results prr

92: CURSOR csr(l_assignment_action_id number, l_input_value_name varchar2, l_element_name varchar2) is
93: SELECT nvl(to_char(fnd_date.canonical_to_date(prrv.result_value),'YYYY/MM/DD'), '0')
94: FROM pay_input_values_f piv
95: ,pay_run_result_values prrv
96: ,pay_run_results prr
97: ,pay_payroll_actions ppa
98: ,pay_assignment_actions paa
99: ,pay_element_types_f pet
100: WHERE paa.assignment_action_id = l_assignment_action_id