APPS.PAY_US_ARCHIVE dependencies on PAY_US_STATES

Line 2203: from pay_us_states pus,

2199: l_some_warning boolean;
2200:
2201: cursor c_get_state_code is
2202: select state_code
2203: from pay_us_states pus,
2204: hr_organization_information hoi
2205: where hoi.organization_id = p_tax_unit_id
2206: and hoi.org_information_context || '' = 'State Tax Rules'
2207: and pus.state_abbrev = hoi.org_information1

Line 3004: pay_us_states pus,

3000: into l_value1,
3001: l_value2,
3002: l_value3
3003: from pay_state_rules rules,
3004: pay_us_states pus,
3005: hr_organization_information target
3006: where substr(rules.jurisdiction_code, 1, 2) = c_state.state_code
3007: and target.organization_id = p_tax_unit_id
3008: and target.org_information_context || '' = 'State Tax Rules'

Line 3561: l_state_abbrev pay_us_states.state_abbrev%type;

3557: l_county_uei ff_user_entities.user_entity_id%type;
3558: l_city_uei ff_user_entities.user_entity_id%type;
3559: l_county_sd_uei ff_user_entities.user_entity_id%type;
3560: l_city_sd_uei ff_user_entities.user_entity_id%type;
3561: l_state_abbrev pay_us_states.state_abbrev%type;
3562: l_county_name pay_us_counties.county_name%type;
3563: l_city_name pay_us_city_names.city_name%type;
3564: l_cnt_sd_name pay_us_county_school_dsts.school_dst_name%type;
3565: l_cty_sd_name pay_us_city_school_dsts.school_dst_name%type;

Line 4306: from pay_us_states pus

4302: l_step := 26;
4303:
4304: select state_abbrev
4305: into l_state_abbrev
4306: from pay_us_states pus
4307: where pus.state_code = substr(l_jurisdiction,1,2);
4308:
4309: l_jd_name_done_tab(l_jd_index).jd_name := l_state_abbrev;
4310: