DBA Data[Home] [Help]

APPS.HR_US_FF_UDF1 dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 6314: FROM PAY_US_EMP_CITY_TAX_RULES_F

6310: BEGIN
6311:
6312: SELECT school_district_code
6313: INTO l_res_city_school_district
6314: FROM PAY_US_EMP_CITY_TAX_RULES_F
6315: WHERE assignment_id = p_assignment_id
6316: AND jurisdiction_code = p_per_addr_geocode
6317: AND l_date_paid between effective_start_date and effective_end_date;
6318:

Line 6391: FROM PAY_US_EMP_CITY_TAX_RULES_F

6387: hr_utility.trace('GET_PSD_JD_CODE: Get work jd school dsts code');
6388:
6389: SELECT school_district_code
6390: INTO l_work_city_school_district
6391: FROM PAY_US_EMP_CITY_TAX_RULES_F
6392: WHERE assignment_id = p_assignment_id
6393: AND jurisdiction_code = p_loc_addr_geocode
6394: AND l_date_paid between effective_start_date and effective_end_date;
6395: