DBA Data[Home] [Help]

APPS.PAY_KR_NONSTAT_SPAY_EFILE_FUN dependencies on FND_DATE

Line 93: SELECT nvl(to_char(fnd_date.canonical_to_date(prrv.result_value),'YYYY/MM/DD'), '0')

89: IS
90: --
91: l_dummy pay_run_result_values.result_value%type;
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