APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 3060: FROM pay_run_result_values rrv

3056: ,p_ele_type_id NUMBER
3057: ,p_assignment_action_id NUMBER) IS
3058: SELECT rrv.result_value val
3059: ,rr.element_entry_id ele_entry_id
3060: FROM pay_run_result_values rrv
3061: ,pay_run_results rr
3062: ,pay_assignment_actions paa
3063: ,pay_payroll_actions ppa
3064: WHERE rrv.input_value_id = p_iv_id

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

3073:
3074: -- rec_get_element csr_get_element%ROWTYPE;
3075: rec_get_add_element csr_get_add_elements%ROWTYPE;
3076:
3077: l_result_value pay_run_result_values.result_value%TYPE := 0;
3078: l_balance_value NUMBER := 0;
3079: l_action_info_id NUMBER;
3080: l_ovn NUMBER;
3081: l_element_context VARCHAR2(10);

Line 4334: FROM pay_run_result_values rrv

4330: ,p_ele_type_id NUMBER
4331: ,p_assignment_action_id NUMBER) IS
4332: SELECT rrv.result_value val
4333: ,rr.element_entry_id ele_entry_id
4334: FROM pay_run_result_values rrv
4335: ,pay_run_results rr
4336: ,pay_assignment_actions paa
4337: ,pay_payroll_actions ppa
4338: WHERE rrv.input_value_id = p_iv_id

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

4423: AND ppa.time_period_id = ptp.time_period_id ;
4424:
4425: -------------------------------------
4426:
4427: l_result_value pay_run_result_values.result_value%TYPE := 0;
4428: l_action_info_id NUMBER;
4429: l_ovn NUMBER;
4430: l_element_context VARCHAR2(10);
4431: l_index NUMBER := 0;