DBA Data[Home] [Help]

APPS.PAY_KR_FF_FUNCTIONS_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 1428: l_flag pay_run_result_values.result_value%type;

1424: ,p_input_value_name in varchar2
1425: ) RETURN VARCHAR2
1426: IS
1427: --
1428: l_flag pay_run_result_values.result_value%type;
1429: -- Bug 7228788: Added a new argument for the Input Value Name to the cursor
1430: CURSOR csr(l_assignment_action_id pay_assignment_actions.assignment_action_id%type, l_input_value_name varchar2) is
1431: SELECT upper(nvl(prrv.result_value, 'N'))
1432: FROM pay_input_values_f piv

Line 1433: ,pay_run_result_values prrv

1429: -- Bug 7228788: Added a new argument for the Input Value Name to the cursor
1430: CURSOR csr(l_assignment_action_id pay_assignment_actions.assignment_action_id%type, l_input_value_name varchar2) is
1431: SELECT upper(nvl(prrv.result_value, 'N'))
1432: FROM pay_input_values_f piv
1433: ,pay_run_result_values prrv
1434: ,pay_run_results prr
1435: ,pay_payroll_actions ppa
1436: ,pay_assignment_actions paa
1437: ,pay_element_types_f pet