DBA Data[Home] [Help]

APPS.PQP_PENSION_EXTRACTS dependencies on PAY_RUN_RESULTS

Line 209: FROM pay_run_results prr

205: CURSOR csr_ele_run (c_asg_action_id IN NUMBER
206: ,c_element_type_id IN NUMBER
207: ) IS
208: SELECT 'X'
209: FROM pay_run_results prr
210: WHERE prr.assignment_action_id = c_asg_action_id
211: AND prr.element_type_id = c_element_type_id;
212: --AND prr.entry_type IN ('E','V','B')
213: --AND prr.status IN ('P','PA');

Line 249: FROM pay_run_results prr

245: CURSOR csr_run (c_asg_action_id IN NUMBER
246: ,c_element_type_id IN NUMBER
247: ,c_input_value_id IN NUMBER) IS
248: SELECT prv.result_value
249: FROM pay_run_results prr
250: ,pay_run_result_values prv
251: WHERE prr.assignment_action_id = c_asg_action_id
252: AND prr.element_type_id = c_element_type_id
253: AND prv.input_value_id = c_input_value_id