eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 302: ,pay_assignment_actions paa

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
306: AND ppa.payroll_id=cp_payroll_id

Line 2735: , pay_assignment_actions ASSACT

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
2739: AND FEED.balance_type_id = cp_balance_type_id

Line 2736: , pay_assignment_actions BAL_ASSACT

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

Line 2767: , pay_assignment_actions ASSACT

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
2771: AND FEED.input_value_id = TARGET.input_value_id

Line 2768: , pay_assignment_actions BAL_ASSACT

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