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 2752: , pay_payroll_actions PACT

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
2754: AND FEED.balance_type_id = cp_balance_type_id
2755: AND FEED.input_value_id = TARGET.input_value_id
2756: AND TARGET.run_result_id = RR.run_result_id

Line 2784: , pay_payroll_actions PACT

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
2786: AND FEED.input_value_id = TARGET.input_value_id
2787: AND TARGET.run_result_id = RR.run_result_id
2788: AND RR.assignment_action_id = ASSACT.assignment_action_id