APPS.PAY_ARCHIVER_REPORT_PKG dependencies on PAY_US_COUNTY_ACTION_INFO_V

Line 1330: from pay_us_county_action_info_v county

1326: sum(county_reduced_subject),
1327: sum(county_withheld),
1328: sum(head_tax_withheld),
1329: decode(non_resident_flag,'NR','WK','R','RS',non_resident_flag)
1330: from pay_us_county_action_info_v county
1331: where county.action_number = cp_action_number
1332: and county.jurisdiction_code
1333: like cp_state_id||'-'||nvl(cp_county_id,'%')||'-0000'
1334: /* and cp_action_number not in (select county2.action_number

Line 1335: from pay_us_county_action_info_v county2

1331: where county.action_number = cp_action_number
1332: and county.jurisdiction_code
1333: like cp_state_id||'-'||nvl(cp_county_id,'%')||'-0000'
1334: /* and cp_action_number not in (select county2.action_number
1335: from pay_us_county_action_info_v county2
1336: where (county2.county_gross = 0
1337: or county2.county_gross is null)
1338: and (county2.county_reduced_subject = 0
1339: or county2.county_reduced_subject is null)