APPS.PAY_ARCHIVER_REPORT_PKG dependencies on PAY_US_COUNTY_ACTION_INFO_V

Line 1133: from pay_us_county_action_info_v county

1129: sum(county_reduced_subject),
1130: sum(county_withheld),
1131: sum(head_tax_withheld),
1132: decode(non_resident_flag,'NR','WK','R','RS',non_resident_flag)
1133: from pay_us_county_action_info_v county
1134: where county.action_number = cp_action_number
1135: and county.jurisdiction_code
1136: like cp_state_id||'-'||nvl(cp_county_id,'%')||'-0000'
1137: /* and cp_action_number not in (select county2.action_number

Line 1138: from pay_us_county_action_info_v county2

1134: where county.action_number = cp_action_number
1135: and county.jurisdiction_code
1136: like cp_state_id||'-'||nvl(cp_county_id,'%')||'-0000'
1137: /* and cp_action_number not in (select county2.action_number
1138: from pay_us_county_action_info_v county2
1139: where (county2.county_gross = 0
1140: or county2.county_gross is null)
1141: and (county2.county_reduced_subject = 0
1142: or county2.county_reduced_subject is null)