DBA Data[Home] [Help]

APPS.PAY_ARCHIVER_REPORT_PKG dependencies on PAY_US_STATE_ACTION_INFO_V

Line 1117: from pay_us_state_action_info_v state

1113: sum(nvl(sdi_er_taxable,0)),
1114: sum(nvl(sdi_er_liability,0)),
1115: sum(nvl(workers_comp_withheld,0)),
1116: sum(nvl(workers_comp2_withheld,0))
1117: from pay_us_state_action_info_v state
1118: where state.action_number = cp_action_number
1119: and state.jurisdiction_code like nvl(cp_state_id,'%')||'-000-0000'
1120: group by jurisdiction_code, jurisdiction_name;
1121: