DBA Data[Home] [Help]

APPS.PQP_US_PENSION_EXTRACTS dependencies on PAY_PAYROLL_ACTIONS

Line 138: ,pay_payroll_actions ppa

134: ,ppa.effective_date
135: ,ppa.action_type
136: ,paa.tax_unit_id
137: FROM pay_assignment_actions paa
138: ,pay_payroll_actions ppa
139: ,pay_action_classifications pac
140: WHERE paa.assignment_id = c_assignment_id
141: AND paa.tax_unit_id = nvl(c_gre_id,paa.tax_unit_id)
142: AND paa.payroll_action_id = ppa.payroll_action_id

Line 4450: pay_payroll_actions ppa,

4446: ,c_end_date IN DATE
4447: ) IS
4448: SELECT paa.assignment_action_id
4449: FROM pay_assignment_actions paa,
4450: pay_payroll_actions ppa,
4451: pay_action_classifications pac
4452: WHERE paa.assignment_id = c_assignment_id
4453: AND paa.tax_unit_id = nvl(c_gre_id,paa.tax_unit_id)
4454: AND paa.payroll_action_id = ppa.payroll_action_id