APPS.PAY_US_ELEMENT_ENTRY_HOOK dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 1103: from pay_us_emp_city_tax_rules_f cty

1099: c_state_code varchar2,
1100: c_county_code varchar2,
1101: c_city_code varchar2) is
1102: select 1
1103: from pay_us_emp_city_tax_rules_f cty
1104: where cty.assignment_id = p_assignment_id
1105: and cty.state_code = c_state_code
1106: and cty.county_code = c_county_code
1107: and cty.city_code = c_city_code;

Line 1150: (p_constraint_name => 'PAY_US_EMP_CITY_TAX_RULES_FK3');

1146: --Bug:7269277 Jurisdiction code length check
1147: elsif length(lv_jurisdiction_code) > 11 then
1148: --Jurisdiction code cannot have size more than 11
1149: pay_cty_shd.constraint_error
1150: (p_constraint_name => 'PAY_US_EMP_CITY_TAX_RULES_FK3');
1151:
1152: end if;
1153: -- Check if Jurisdiction is specified
1154: if lv_jurisdiction_code IS NOT NULL then

Line 1161: (p_constraint_name => 'PAY_US_EMP_CITY_TAX_RULES_FK3');

1157: if instr(lv_jurisdiction_code,'-', 1,1) <> 3
1158: or instr(lv_jurisdiction_code,'-', 1,2) <> 7 then
1159:
1160: pay_cty_shd.constraint_error
1161: (p_constraint_name => 'PAY_US_EMP_CITY_TAX_RULES_FK3');
1162: end if;
1163:
1164: /*Changes for Bug#9270887 */
1165: --Check if Default Tax Records exist for this Assignment.If not present,