DBA Data[Home] [Help]

APPS.PQP_ALIEN_EXPAT_TAXATION_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 162: ,pay_assignment_actions paa

158: select 'Y' from
159: dual where exists
160: (select ppa.date_earned
161: from pay_payroll_actions ppa
162: ,pay_assignment_actions paa
163: ,pay_run_results prr
164: ,pay_element_types_f pet
165: ,pay_element_classifications pec
166: ,per_assignments_f paf

Line 3344: ,pay_assignment_actions paa

3340: ,p_effective_date in date ) is
3341: select max(ppa.effective_date) date_paid ,
3342: max(ppa.date_earned) date_earned
3343: from pay_payroll_actions ppa
3344: ,pay_assignment_actions paa
3345: ,per_assignments_f paf
3346: where ppa.payroll_action_id = paa.payroll_action_id
3347: and paa.assignment_id = paf.assignment_id
3348: and ppa.action_status = 'C'