APPS.PAY_CTY_BUS dependencies on PAY_US_EMP_COUNTY_TAX_RULES_F

Line 939: pay_us_emp_county_tax_rules_f.school_district_code%TYPE;

935: pay_us_emp_city_tax_rules_f.school_district_code%TYPE;
936: l_cty_schl_dist_code
937: pay_us_emp_city_tax_rules_f.school_district_code%TYPE;
938: l_cnt_schl_dist_code
939: pay_us_emp_county_tax_rules_f.school_district_code%TYPE;
940: l_api_updating boolean;
941: --
942: cursor csr_school_district_code (p_sta_code varchar2,
943: p_cnt_code varchar2,

Line 977: from pay_us_emp_county_tax_rules_f ctr

973: p_asg_id number,
974: p_sta_code varchar2,
975: p_cnt_code varchar2) is
976: select school_district_code
977: from pay_us_emp_county_tax_rules_f ctr
978: where ctr.assignment_id = p_asg_id
979: and ctr.effective_end_date >= p_validation_start_date
980: and ctr.effective_start_date <= p_validation_end_date
981: and ctr.school_district_code is not null