DBA Data[Home] [Help]

APPS.PQP_ALIEN_EXPAT_TAXATION_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 161: from pay_payroll_actions ppa

157: ,p_income_code in varchar2 ) is
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

Line 3349: from pay_payroll_actions ppa

3345: cursor c_date_paid_earned(p_person_id in number
3346: ,p_effective_date in date ) is
3347: select max(ppa.effective_date) date_paid ,
3348: max(ppa.date_earned) date_earned
3349: from pay_payroll_actions ppa
3350: ,pay_assignment_actions paa
3351: ,per_assignments_f paf
3352: where ppa.payroll_action_id = paa.payroll_action_id
3353: and paa.assignment_id = paf.assignment_id