APPS.HR_US_FF_UDF1 dependencies on PAY_US_SCHOOL_DSTS_TAX_INFO_F

Line 6334: FROM pay_us_school_dsts_tax_info_f

6330: hr_utility.trace('GET_PSD_JD_CODE: Get resident PSD WITH School dsts code');
6331:
6332: SELECT sch_information_category
6333: INTO l_res_psd_code
6334: FROM pay_us_school_dsts_tax_info_f
6335: WHERE jurisdiction_code = p_per_addr_geocode
6336: AND school_dsts_code = l_res_city_school_district
6337: AND l_date_paid between effective_start_date and effective_end_date
6338: AND SCH_INFORMATION1 = 'PSDCODES';

Line 6370: FROM pay_us_school_dsts_tax_info_f

6366: hr_utility.trace('GET_PSD_JD_CODE: Get work PSD WITHOUT school dsts code');
6367:
6368: SELECT sch_information_category
6369: INTO l_work_psd_code
6370: FROM pay_us_school_dsts_tax_info_f
6371: WHERE jurisdiction_code = p_loc_addr_geocode
6372: AND l_date_paid between effective_start_date and effective_end_date
6373: AND SCH_INFORMATION1 = 'PSDCODES';
6374:

Line 6402: FROM pay_us_school_dsts_tax_info_f

6398: hr_utility.trace('GET_PSD_JD_CODE: Get work PSD WITH School dsts code');
6399:
6400: SELECT sch_information_category
6401: INTO l_work_psd_code
6402: FROM pay_us_school_dsts_tax_info_f
6403: WHERE jurisdiction_code = p_loc_addr_geocode
6404: AND school_dsts_code = l_work_city_school_district
6405: AND l_date_paid between effective_start_date and effective_end_date
6406: AND SCH_INFORMATION1 = 'PSDCODES';