APPS.PAY_US_ARCHIVE dependencies on PAY_US_STATES

Line 1892: from pay_us_states pus,

1888: l_w2_profile_option VARCHAR2(10);
1889:
1890: cursor c_get_state_code is
1891: select state_code
1892: from pay_us_states pus,
1893: hr_organization_information hoi
1894: where hoi.organization_id = p_tax_unit_id
1895: and hoi.org_information_context || '' = 'State Tax Rules'
1896: and pus.state_abbrev = hoi.org_information1

Line 2494: pay_us_states pus,

2490: into l_value1,
2491: l_value2,
2492: l_value3
2493: from pay_state_rules rules,
2494: pay_us_states pus,
2495: hr_organization_information target
2496: where substr(rules.jurisdiction_code, 1, 2) = c_state.state_code
2497: and target.organization_id = p_tax_unit_id
2498: and target.org_information_context || '' = 'State Tax Rules'

Line 2989: l_state_abbrev pay_us_states.state_abbrev%type;

2985: l_county_uei ff_user_entities.user_entity_id%type;
2986: l_city_uei ff_user_entities.user_entity_id%type;
2987: l_county_sd_uei ff_user_entities.user_entity_id%type;
2988: l_city_sd_uei ff_user_entities.user_entity_id%type;
2989: l_state_abbrev pay_us_states.state_abbrev%type;
2990: l_county_name pay_us_counties.county_name%type;
2991: l_city_name pay_us_city_names.city_name%type;
2992: l_cnt_sd_name pay_us_county_school_dsts.school_dst_name%type;
2993: l_cty_sd_name pay_us_city_school_dsts.school_dst_name%type;

Line 3674: from pay_us_states pus

3670: l_step := 26;
3671:
3672: select state_abbrev
3673: into l_state_abbrev
3674: from pay_us_states pus
3675: where pus.state_code = substr(l_jurisdiction,1,2);
3676:
3677: l_jd_name_done_tab(l_jd_index).jd_name := l_state_abbrev;
3678: