APPS.PQP_INI_BAL dependencies on PAY_RUN_RESULTS

Line 1258: ,pay_run_results RR

1254: FEED.scale),0) tot
1255: from
1256: pay_balance_feeds_f FEED
1257: ,pay_run_result_values TARGET
1258: ,pay_run_results RR
1259: ,pay_payroll_actions PACT
1260: ,pay_assignment_actions ASSACT
1261: ,pay_payroll_actions BACT
1262: ,per_time_periods BPTP

Line 1420: , pay_run_results RR

1416: SELECT nvl((fnd_number.canonical_to_number(TARGET.result_value)
1417: * FEED.scale),0) tot
1418: FROM pay_run_result_values TARGET
1419: , pay_balance_feeds_f FEED
1420: , pay_run_results RR
1421: , pay_assignment_actions ASSACT
1422: , pay_assignment_actions BAL_ASSACT
1423: , pay_payroll_actions PACT
1424: WHERE BAL_ASSACT.assignment_action_id = cp_assignment_action_id

Line 1439: ( SELECT null from pay_run_results rr1

1435: AND ASSACT.assignment_id = BAL_ASSACT.assignment_id
1436: AND (( RR.source_id = cp_element_entry_id and source_type in ( 'E','I'))
1437: OR ( rr.source_type in ('R','V') /* reversal */
1438: AND exists
1439: ( SELECT null from pay_run_results rr1
1440: WHERE rr1.source_id = cp_element_entry_id
1441: AND rr1.run_result_id = rr.source_id
1442: AND rr1.source_type in ( 'E','I'))));
1443:

Line 1524: ,pay_run_results prr

1520: ,to_number(NULL) Actual_Mileage
1521: From pay_element_types_f pet
1522: ,pay_element_type_extra_info petei
1523: ,pay_assignment_actions paa
1524: ,pay_run_results prr
1525: ,pay_payroll_actions ppa
1526: WHERE pet.business_group_id = p_business_group_id
1527: AND pet.element_type_id=petei.element_type_id
1528: AND petei.information_type='PQP_VEHICLE_MILEAGE_INFO'