DBA Data[Home] [Help]

APPS.PAY_STA_BUS dependencies on PAY_PAYROLL_ACTIONS

Line 1286: from pay_payroll_actions ppa

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