APPS.PAY_ARCHIVER_REPORT_PKG dependencies on PAY_US_CITY_ACTION_INFO_V

Line 1368: from pay_us_city_action_info_v city

1364: sum(city_reduced_subject),
1365: sum(city_withheld),
1366: sum(head_tax_withheld),
1367: decode(non_resident_flag,'NR','WK','R','RS',non_resident_flag)
1368: from pay_us_city_action_info_v city
1369: where city.action_number = cp_action_number
1370: and city.jurisdiction_code
1371: like cp_state_id||'-'||nvl(cp_county_id,'%')||'-'||nvl(cp_city_id,'%')
1372: /* and cp_action_number not in (select city2.action_number

Line 1373: from pay_us_city_action_info_v city2

1369: where city.action_number = cp_action_number
1370: and city.jurisdiction_code
1371: like cp_state_id||'-'||nvl(cp_county_id,'%')||'-'||nvl(cp_city_id,'%')
1372: /* and cp_action_number not in (select city2.action_number
1373: from pay_us_city_action_info_v city2
1374: where (city2.city_gross = 0
1375: or city2.city_gross is null)
1376: and (city2.city_reduced_subject = 0
1377: or city2.city_reduced_subject is null)