APPS.PAY_US_ACTION_ARCH dependencies on PAY_US_COUNTY_TAX_INFO_F

Line 1122: from pay_us_county_tax_info_f

1118: select jurisdiction_code,
1119: county_tax,
1120: head_tax,
1121: school_tax
1122: from pay_us_county_tax_info_f
1123: where cp_effective_date between effective_start_date
1124: and effective_end_date
1125: and cnty_information_category = 'County tax status info'
1126: order by 1 ;

Line 6422: from pay_us_county_tax_info_f

6418: date_ear between pet1.effective_start_date and pet1.effective_end_date;
6419:
6420: cursor cnty ( jur_code varchar2, date_ear date ) IS
6421: select cnty_information1
6422: from pay_us_county_tax_info_f
6423: where jurisdiction_code = jur_code and
6424: date_ear between effective_start_date and effective_end_date;
6425:
6426: cursor state ( st_code varchar2, date_ear date ) IS

Line 6684: -- from pay_us_county_tax_info_f with the cnty_information1

6680: l_county := substr(l_jurisdiction,1,6) || '-0000' ;
6681: END IF;
6682:
6683: -- Get the print_ssn for a county
6684: -- from pay_us_county_tax_info_f with the cnty_information1
6685: -- For example Monroe County in Ohio State should return Y
6686:
6687: l_print_ssn := null;
6688: l_print_wages := null;