APPS.PAY_ARCHIVER_REPORT_PKG dependencies on PAY_US_STATE_ACTION_INFO_V

Line 1300: from pay_us_state_action_info_v state

1296: sum(nvl(sdi_er_liability,0)),
1297: sum(nvl(workers_comp_withheld,0)),
1298: sum(nvl(workers_comp2_withheld,0)),
1299: sum(nvl(SDI1_EE_Withheld,0))
1300: from pay_us_state_action_info_v state
1301: where state.action_number = cp_action_number
1302: and state.jurisdiction_code like nvl(cp_state_id,'%')||'-000-0000'
1303: group by jurisdiction_code, jurisdiction_name
1304: having sum(abs(nvl(sit_gross,0))) +