DBA Data[Home] [Help]

APPS.PAY_CPT_BUS dependencies on PAY_PAYROLL_ACTIONS

Line 1354: from pay_payroll_actions ppa,

1350: and PR.emp_province_tax_inf_id = p_rec.emp_province_tax_inf_id
1351: and paf.assignment_id = PR.assignment_id
1352: and paf.assignment_id = paa.assignment_id
1353: and exists (select null
1354: from pay_payroll_actions ppa,
1355: pay_payrolls_f ppf
1356: where ppa.payroll_action_id = paa.payroll_action_id
1357: and ppa.action_type in ('Q','R')
1358: and ppa.date_earned > p_csr_tmp_date