DBA Data[Home] [Help]

APPS.PAYUSUNB_PKG dependencies on PAY_US_COUNTY_SCHOOL_DSTS

Line 1963: pay_us_county_school_dsts psd

1959: psd.state_code||'-'||psd.county_code||'-0000' reg_jurisdiction_cd
1960: FROM per_assignments_f paf,
1961: pay_run_balances prb,
1962: pay_us_states pus,
1963: pay_us_county_school_dsts psd
1964: WHERE paf.person_id = IN_person_id
1965: AND paf.effective_start_date <= IN_as_of_date
1966: AND paf.effective_end_date >= IN_start_date
1967: AND prb.assignment_id = paf.assignment_id

Line 2177: pay_us_county_school_dsts psd

2173: pes.jurisdiction_code reg_jurisdiction_cd
2174: FROM pay_us_emp_county_tax_rules_f pes,
2175: per_assignments_f paf,
2176: pay_us_states pus,
2177: pay_us_county_school_dsts psd
2178: WHERE pes.assignment_id = paf.assignment_id
2179: AND pes.school_district_code IS NOT NULL
2180: AND pes.state_code = pus.state_code
2181: AND pes.school_district_code = psd.school_dst_code