APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 301: FROM pay_payroll_actions ppa

297: IS
298: SELECT ptp.start_date,ptp.end_date
299: FROM per_time_periods ptp
300: WHERE (ptp.end_date > ( SELECT MAX(effective_date)
301: FROM pay_payroll_actions ppa
302: ,pay_assignment_actions paa
303: WHERE ppa.action_status='C'
304: AND ppa.action_type in ('R','Q')
305: AND ppa.business_group_id=cp_business_group_id

Line 2737: , pay_payroll_actions PACT

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
2739: AND FEED.balance_type_id = cp_balance_type_id
2740: AND FEED.input_value_id = TARGET.input_value_id
2741: AND TARGET.run_result_id = RR.run_result_id

Line 2769: , pay_payroll_actions PACT

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
2771: AND FEED.input_value_id = TARGET.input_value_id
2772: AND TARGET.run_result_id = RR.run_result_id
2773: AND RR.assignment_action_id = ASSACT.assignment_action_id