APPS.PAY_CNT_BUS dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 868: pay_us_emp_city_tax_rules_f.school_district_code%TYPE;

864: l_proc varchar2(72) := g_package||'chk_school_district_code';
865: l_school_district_code
866: pay_us_emp_county_tax_rules_f.school_district_code%TYPE;
867: l_cty_schl_dist_code
868: pay_us_emp_city_tax_rules_f.school_district_code%TYPE;
869: l_cnt_schl_dist_code
870: pay_us_emp_county_tax_rules_f.school_district_code%TYPE;
871: l_api_updating boolean;
872: --

Line 887: from pay_us_emp_city_tax_rules_f ctr

883: p_asg_id number,
884: p_sta_code varchar2,
885: p_cnt_code varchar2) is
886: select school_district_code
887: from pay_us_emp_city_tax_rules_f ctr
888: where ctr.assignment_id = p_asg_id
889: and ctr.effective_end_date >= p_val_start_date
890: and ctr.effective_start_date <= p_val_end_date
891: and ctr.school_district_code is not null

Line 1203: from pay_us_emp_city_tax_rules_f cty

1199: --
1200: cursor chk_city_tax_rules
1201: is
1202: select null
1203: from pay_us_emp_city_tax_rules_f cty
1204: where cty.assignment_id = p_assignment_id
1205: and cty.state_code = p_state_code
1206: and cty.county_code = p_county_code
1207: and cty.effective_end_date > p_effective_date;

Line 1280: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_CITY_TAX_RULES_F');

1276: fetch chk_city_tax_rules into l_city_rule_exists;
1277: if chk_city_tax_rules%found then
1278: close chk_city_tax_rules;
1279: hr_utility.set_message(801,'HR_7215_DT_CHILD_EXISTS');
1280: hr_utility.set_message_token('TABLE_NAME','PAY_US_EMP_CITY_TAX_RULES_F');
1281: hr_utility.raise_error;
1282: end if;
1283: close chk_city_tax_rules;
1284: --