DBA Data[Home] [Help]

APPS.PQP_PENSION_EXTRACTS dependencies on PAY_PAYROLL_ACTIONS

Line 97: ,pay_payroll_actions ppa

93: ,ppa.effective_date
94: ,ppa.action_type
95: ,paa.tax_unit_id
96: FROM pay_assignment_actions paa
97: ,pay_payroll_actions ppa
98: WHERE paa.assignment_id = c_assignment_id
99: AND ppa.action_status = 'C'
100: AND paa.action_status = 'C'
101: AND paa.payroll_action_id = ppa.payroll_action_id

Line 122: pay_payroll_actions ppa,

118: ,ppa.effective_date
119: ,ppa.action_type
120: ,paa.tax_unit_id
121: FROM pay_assignment_actions paa,
122: pay_payroll_actions ppa,
123: pay_action_classifications pac
124: WHERE paa.assignment_id = c_assignment_id
125: AND (c_gre_id is null or
126: paa.tax_unit_id = nvl(c_gre_id,paa.tax_unit_id)

Line 170: pay_payroll_actions ppa,

166: ,ppa.effective_date
167: ,ppa.action_type
168: ,paa.tax_unit_id
169: FROM pay_assignment_actions paa,
170: pay_payroll_actions ppa,
171: pay_action_classifications pac
172: WHERE paa.assignment_id = c_assignment_id
173: AND (c_gre_id is null or
174: paa.tax_unit_id = nvl(c_gre_id,paa.tax_unit_id)