DBA Data[Home] [Help]

APPS.PAYUSUNB_PKG dependencies on PAY_US_CITY_SCHOOL_DSTS

Line 1940: pay_us_city_school_dsts psd

1936: psd.state_code||'-'||psd.county_code||'-'||psd.city_code reg_jurisdiction_cd
1937: FROM pay_run_balances prb,
1938: per_assignments_f paf,
1939: pay_us_states pus,
1940: pay_us_city_school_dsts psd
1941: WHERE paf.person_id = IN_person_id
1942: AND paf.effective_start_date <= IN_as_of_date
1943: AND paf.effective_end_date >= IN_start_date
1944: AND paf.assignment_id = prb.assignment_id

Line 2134: pay_us_city_school_dsts psd

2130: pes.jurisdiction_code reg_jurisdiction_cd
2131: FROM pay_us_emp_city_tax_rules_f pes,
2132: per_assignments_f paf,
2133: pay_us_states pus,
2134: pay_us_city_school_dsts psd
2135: WHERE pes.assignment_id = paf.assignment_id
2136: AND pes.school_district_code IS NOT NULL
2137: AND pes.state_code = pus.state_code
2138: AND pes.school_district_code = psd.school_dst_code