APPS.PAY_FI_ARCHIVE_PYSA dependencies on PAY_RUN_RESULT_VALUES

Line 1609: FROM pay_run_result_values rrv

1605: CURSOR csr_result_value(p_iv_id NUMBER
1606: ,p_ele_type_id NUMBER
1607: ,p_assignment_action_id NUMBER) IS
1608: SELECT rrv.result_value
1609: FROM pay_run_result_values rrv
1610: ,pay_run_results rr
1611: ,pay_assignment_actions paa
1612: ,pay_payroll_actions ppa
1613: WHERE rrv.input_value_id = p_iv_id

Line 1622: l_result_value pay_run_result_values.result_value%TYPE := 0;

1618: AND ppa.payroll_action_id = paa.payroll_action_id
1619: AND ppa.action_type IN ('Q','R')
1620: AND rrv.result_value IS NOT NULL;
1621: rec_get_element csr_get_element%ROWTYPE;
1622: l_result_value pay_run_result_values.result_value%TYPE := 0;
1623: l_action_info_id NUMBER;
1624: l_ovn NUMBER;
1625: l_element_context VARCHAR2(10);
1626: l_index NUMBER := 0;

Line 2784: FROM pay_run_result_values rrv

2780: CURSOR csr_result_value(p_iv_id NUMBER
2781: ,p_ele_type_id NUMBER
2782: ,p_assignment_action_id NUMBER) IS
2783: SELECT rrv.result_value
2784: FROM pay_run_result_values rrv
2785: ,pay_run_results rr
2786: ,pay_assignment_actions paa
2787: ,pay_payroll_actions ppa
2788: WHERE rrv.input_value_id = p_iv_id

Line 2798: l_result_value pay_run_result_values.result_value%TYPE := 0;

2794: AND ppa.action_type IN ('Q','R')
2795: AND rrv.result_value IS NOT NULL;
2796: -----------------------------------------------------------------------------
2797:
2798: l_result_value pay_run_result_values.result_value%TYPE := 0;
2799: l_action_info_id NUMBER;
2800: l_ovn NUMBER;
2801: l_element_context VARCHAR2(10);
2802: l_index NUMBER := 0;