DBA Data[Home] [Help]

APPS.PQP_CLM_BAL dependencies on PAY_PAYROLL_ACTIONS

Line 27: ,pay_payroll_actions ppa

23: FROM pay_element_types_f pet
24: ,pay_element_type_extra_info pete
25: ,pay_run_results prr
26: ,pay_assignment_actions paas
27: ,pay_payroll_actions ppa
28: where
29: pete.EEI_INFORMATION_CATEGORY='PQP_VEHICLE_MILEAGE_INFO'
30: AND pet.element_type_id=pete.element_type_id
31: AND pete.EEI_INFORMATION1 in ('C','P','CM','CP','PP','PM')

Line 119: , pay_payroll_actions PACT

115: , pay_balance_feeds_f FEED
116: , pay_run_results RR
117: , pay_assignment_actions ASSACT
118: , pay_assignment_actions BAL_ASSACT
119: , pay_payroll_actions PACT
120: WHERE BAL_ASSACT.assignment_action_id = cp_assignment_action_id
121: AND FEED.balance_type_id = cp_balance_type_id
122: AND FEED.input_value_id = TARGET.input_value_id
123: AND TARGET.run_result_id = RR.run_result_id