DBA Data[Home] [Help]

APPS.PAY_STA_BUS dependencies on PAY_PAYROLL_ACTIONS

Line 1283: from pay_payroll_actions ppa

1279: where substr(prr.jurisdiction_code,1,2)=pay_sta_shd.g_old_rec.state_code
1280: and paa.assignment_action_id = prr.assignment_action_id
1281: and paa.assignment_id = pay_sta_shd.g_old_rec.assignment_id
1282: and exists (select null
1283: from pay_payroll_actions ppa
1284: where ppa.payroll_action_id = paa.payroll_action_id
1285: and ppa.action_type in ('Q','R')
1286: and ppa.date_earned > p_csr_tmp_date
1287: );