APPS.PQP_CLM_BAL dependencies on PAY_RUN_RESULTS

Line 25: ,pay_run_results prr

21: ,prr.source_type
22: ,prr.run_result_id
23: FROM pay_element_types_f pet
24: ,pay_element_type_extra_info pete
25: ,pay_run_results prr
26: ,pay_assignment_actions paas
27: ,pay_payroll_actions ppa
28: where
29: pete.EEI_INFORMATION_CATEGORY='PQP_VEHICLE_MILEAGE_INFO'

Line 47: FROM pay_run_results rr1,

43:
44: CURSOR c_src_ele_entry_id(cp_run_result_id NUMBER)
45: IS
46: Select rr2.source_id
47: FROM pay_run_results rr1,
48: pay_run_results rr2
49: WHERE
50: rr1.run_result_id = cp_run_result_id
51: AND rr1.source_id = rr2.run_result_id;

Line 48: pay_run_results rr2

44: CURSOR c_src_ele_entry_id(cp_run_result_id NUMBER)
45: IS
46: Select rr2.source_id
47: FROM pay_run_results rr1,
48: pay_run_results rr2
49: WHERE
50: rr1.run_result_id = cp_run_result_id
51: AND rr1.source_id = rr2.run_result_id;
52:

Line 116: , pay_run_results RR

112: SELECT nvl((fnd_number.canonical_to_number(TARGET.result_value)
113: * FEED.scale),0) tot
114: FROM pay_run_result_values TARGET
115: , pay_balance_feeds_f FEED
116: , pay_run_results RR
117: , pay_assignment_actions ASSACT
118: , pay_assignment_actions BAL_ASSACT
119: , pay_payroll_actions PACT
120: WHERE BAL_ASSACT.assignment_action_id = cp_assignment_action_id

Line 135: ( SELECT null from pay_run_results rr1

131: AND ASSACT.assignment_id = BAL_ASSACT.assignment_id
132: AND (( RR.source_id = cp_element_entry_id and source_type in ( 'E','I'))
133: OR ( rr.source_type in ('R','V') /* reversal */
134: AND exists
135: ( SELECT null from pay_run_results rr1
136: WHERE rr1.source_id = cp_element_entry_id
137: AND rr1.run_result_id = rr.source_id
138: AND rr1.source_type in ( 'E','I'))));
139: