APPS.HR_US_FF_UDF1 dependencies on PAY_US_STATES

Line 5083: pay_us_states pus

5079: CURSOR csr_state_rules(p_tax_unit_id IN NUMBER
5080: ,p_state_code IN VARCHAR2) IS
5081: SELECT NVL(org_information2,0)
5082: FROM hr_organization_information hoi,
5083: pay_us_states pus
5084: WHERE hoi.organization_id = p_tax_unit_id
5085: AND hoi.org_information_context = 'State Tax Rules 2'
5086: AND hoi.org_information1 = pus.state_abbrev
5087: AND pus.state_code = p_state_code;

Line 5521: pay_us_states pus,

5517:
5518: CURSOR c_override_jd (p_assignment_id IN NUMBER,p_date_earned IN DATE) IS
5519: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
5520: FROM pay_us_counties puc,
5521: pay_us_states pus,
5522: pay_us_city_names pucty,
5523: per_addresses pa,
5524: per_assignments_f paf
5525: WHERE paf.assignment_id = p_assignment_id

Line 5546: pay_us_states pus,

5542:
5543: CURSOR c_jd (p_assignment_id IN NUMBER,p_date_earned IN DATE) IS
5544: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
5545: FROM pay_us_counties puc,
5546: pay_us_states pus,
5547: pay_us_city_names pucty,
5548: per_addresses pa,
5549: per_assignments_f paf
5550: WHERE paf.assignment_id = p_assignment_id

Line 5609: pay_us_states pus,

5605: p_date_earned IN DATE,
5606: p_jurisdiction_code IN VARCHAR2) IS
5607: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
5608: FROM pay_us_counties puc,
5609: pay_us_states pus,
5610: pay_us_city_names pucty,
5611: hr_locations hl,
5612: per_assignments_f paf
5613: WHERE paf.assignment_id = p_assignment_id

Line 5632: pay_us_states pus,

5628: p_date_earned IN DATE,
5629: p_jurisdiction_code IN VARCHAR2) IS
5630: SELECT puc.state_code || '-' || puc.county_code || '-' ||pucty.city_code
5631: FROM pay_us_counties puc,
5632: pay_us_states pus,
5633: pay_us_city_names pucty,
5634: hr_locations hl,
5635: per_assignments_f paf
5636: WHERE paf.assignment_id = p_assignment_id