APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PAY_RUN_RESULTS

Line 1648: FROM pay_run_results prr

1644: ,cp_element_entry_id NUMBER
1645: )
1646: IS
1647: SELECT prr.assignment_action_id
1648: FROM pay_run_results prr
1649: WHERE
1650: --prr.assignment_id =cp_assignment_id
1651: --AND
1652: prr.element_type_id=cp_element_type_id

Line 2749: , pay_run_results RR

2745: SELECT nvl(SUM(fnd_number.canonical_to_number(TARGET.result_value)
2746: * FEED.scale),0) tot
2747: FROM pay_run_result_values TARGET
2748: , pay_balance_feeds_f FEED
2749: , pay_run_results RR
2750: , pay_assignment_actions ASSACT
2751: , pay_assignment_actions BAL_ASSACT
2752: , pay_payroll_actions PACT
2753: WHERE BAL_ASSACT.assignment_action_id = cp_assignment_action_id

Line 2767: ( SELECT null from pay_run_results rr1

2763: AND ASSACT.assignment_id = BAL_ASSACT.assignment_id
2764: AND (( RR.source_id = cp_element_entry_id and source_type in ( 'E','I'))
2765: OR ( rr.source_type in ('R','V') /* reversal */
2766: AND exists
2767: ( SELECT null from pay_run_results rr1
2768: WHERE rr1.source_id = cp_element_entry_id
2769: AND rr1.run_result_id = rr.source_id
2770: AND rr1.source_type in ( 'E','I'))));
2771:

Line 2781: , pay_run_results RR

2777: IS
2778: SELECT target.result_value tot
2779: FROM pay_run_result_values TARGET
2780: , pay_balance_feeds_f FEED
2781: , pay_run_results RR
2782: , pay_assignment_actions ASSACT
2783: , pay_assignment_actions BAL_ASSACT
2784: , pay_payroll_actions PACT
2785: WHERE bal_assact.assignment_action_id = cp_assignment_action_id

Line 2799: ( SELECT null from pay_run_results rr1

2795: AND rr.element_type_id=cp_element_type_id
2796: AND (( RR.source_id = cp_element_entry_id and source_type in ( 'E','I'))
2797: OR ( rr.source_type in ('R','V')
2798: AND exists
2799: ( SELECT null from pay_run_results rr1
2800: WHERE rr1.source_id = cp_element_entry_id
2801: AND rr1.run_result_id = rr.source_id
2802: AND rr1.source_type in ( 'E','I'))))
2803: and feed.balance_type_id=cp_balance_type_id;