APPS.HR_US_FF_UDF1 dependencies on PAY_US_STATES

Line 5270: pay_us_states pus

5266: CURSOR csr_state_rules(p_tax_unit_id IN NUMBER
5267: ,p_state_code IN VARCHAR2) IS
5268: SELECT NVL(org_information2,0)
5269: FROM hr_organization_information hoi,
5270: pay_us_states pus
5271: WHERE hoi.organization_id = p_tax_unit_id
5272: AND hoi.org_information_context = 'State Tax Rules 2'
5273: AND hoi.org_information1 = pus.state_abbrev
5274: AND pus.state_code = p_state_code;

Line 5708: pay_us_states pus,

5704:
5705: CURSOR c_override_jd (p_assignment_id IN NUMBER,p_date_earned IN DATE) IS
5706: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
5707: FROM pay_us_counties puc,
5708: pay_us_states pus,
5709: pay_us_city_names pucty,
5710: per_addresses pa,
5711: per_assignments_f paf
5712: WHERE paf.assignment_id = p_assignment_id

Line 5733: pay_us_states pus,

5729:
5730: CURSOR c_jd (p_assignment_id IN NUMBER,p_date_earned IN DATE) IS
5731: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
5732: FROM pay_us_counties puc,
5733: pay_us_states pus,
5734: pay_us_city_names pucty,
5735: per_addresses pa,
5736: per_assignments_f paf
5737: WHERE paf.assignment_id = p_assignment_id

Line 5796: pay_us_states pus,

5792: p_date_earned IN DATE,
5793: p_jurisdiction_code IN VARCHAR2) IS
5794: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
5795: FROM pay_us_counties puc,
5796: pay_us_states pus,
5797: pay_us_city_names pucty,
5798: hr_locations hl,
5799: per_assignments_f paf
5800: WHERE paf.assignment_id = p_assignment_id

Line 5819: pay_us_states pus,

5815: p_date_earned IN DATE,
5816: p_jurisdiction_code IN VARCHAR2) IS
5817: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
5818: FROM pay_us_counties puc,
5819: pay_us_states pus,
5820: pay_us_city_names pucty,
5821: hr_locations hl,
5822: per_assignments_f paf
5823: WHERE paf.assignment_id = p_assignment_id