APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PAY_RUN_RESULTS

Line 1636: FROM pay_run_results prr

1632: ,cp_element_entry_id NUMBER
1633: )
1634: IS
1635: SELECT prr.assignment_action_id
1636: FROM pay_run_results prr
1637: WHERE
1638: --prr.assignment_id =cp_assignment_id
1639: --AND
1640: prr.element_type_id=cp_element_type_id

Line 2734: , pay_run_results RR

2730: SELECT nvl(SUM(fnd_number.canonical_to_number(TARGET.result_value)
2731: * FEED.scale),0) tot
2732: FROM pay_run_result_values TARGET
2733: , pay_balance_feeds_f FEED
2734: , pay_run_results RR
2735: , pay_assignment_actions ASSACT
2736: , pay_assignment_actions BAL_ASSACT
2737: , pay_payroll_actions PACT
2738: WHERE BAL_ASSACT.assignment_action_id = cp_assignment_action_id

Line 2752: ( SELECT null from pay_run_results rr1

2748: AND ASSACT.assignment_id = BAL_ASSACT.assignment_id
2749: AND (( RR.source_id = cp_element_entry_id and source_type in ( 'E','I'))
2750: OR ( rr.source_type in ('R','V') /* reversal */
2751: AND exists
2752: ( SELECT null from pay_run_results rr1
2753: WHERE rr1.source_id = cp_element_entry_id
2754: AND rr1.run_result_id = rr.source_id
2755: AND rr1.source_type in ( 'E','I'))));
2756:

Line 2766: , pay_run_results RR

2762: IS
2763: SELECT target.result_value tot
2764: FROM pay_run_result_values TARGET
2765: , pay_balance_feeds_f FEED
2766: , pay_run_results RR
2767: , pay_assignment_actions ASSACT
2768: , pay_assignment_actions BAL_ASSACT
2769: , pay_payroll_actions PACT
2770: WHERE bal_assact.assignment_action_id = cp_assignment_action_id

Line 2784: ( SELECT null from pay_run_results rr1

2780: AND rr.element_type_id=cp_element_type_id
2781: AND (( RR.source_id = cp_element_entry_id and source_type in ( 'E','I'))
2782: OR ( rr.source_type in ('R','V')
2783: AND exists
2784: ( SELECT null from pay_run_results rr1
2785: WHERE rr1.source_id = cp_element_entry_id
2786: AND rr1.run_result_id = rr.source_id
2787: AND rr1.source_type in ( 'E','I'))))
2788: and feed.balance_type_id=cp_balance_type_id;