APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 3071: FROM pay_run_result_values rrv

3067: ,p_ele_type_id NUMBER
3068: ,p_assignment_action_id NUMBER) IS
3069: SELECT rrv.result_value val
3070: ,rr.element_entry_id ele_entry_id
3071: FROM pay_run_result_values rrv
3072: ,pay_run_results rr
3073: ,pay_assignment_actions paa
3074: ,pay_payroll_actions ppa
3075: WHERE rrv.input_value_id = p_iv_id

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

3084:
3085: -- rec_get_element csr_get_element%ROWTYPE;
3086: rec_get_add_element csr_get_add_elements%ROWTYPE;
3087:
3088: l_result_value pay_run_result_values.result_value%TYPE := 0;
3089: l_balance_value NUMBER := 0;
3090: l_action_info_id NUMBER;
3091: l_ovn NUMBER;
3092: l_element_context VARCHAR2(10);

Line 4345: FROM pay_run_result_values rrv

4341: ,p_ele_type_id NUMBER
4342: ,p_assignment_action_id NUMBER) IS
4343: SELECT rrv.result_value val
4344: ,rr.element_entry_id ele_entry_id
4345: FROM pay_run_result_values rrv
4346: ,pay_run_results rr
4347: ,pay_assignment_actions paa
4348: ,pay_payroll_actions ppa
4349: WHERE rrv.input_value_id = p_iv_id

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

4434: AND ppa.time_period_id = ptp.time_period_id ;
4435:
4436: -------------------------------------
4437:
4438: l_result_value pay_run_result_values.result_value%TYPE := 0;
4439: l_action_info_id NUMBER;
4440: l_ovn NUMBER;
4441: l_element_context VARCHAR2(10);
4442: l_index NUMBER := 0;