APPS.PAY_US_ELEMENT_ENTRY_HOOK dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 1071: from pay_us_emp_fed_tax_rules_f sta

1067: -- Cursor to check the existence of Default Tax Rules for
1068: -- the assignment.Can check existence of Federal Tax Rule alone for this.
1069: cursor c_default_tax_rule(c_assignment_id number) is
1070: select 1
1071: from pay_us_emp_fed_tax_rules_f sta
1072: where sta.assignment_id = c_assignment_id;
1073: /*End Bug#9270887 */
1074:
1075: -- Cursor to check the existence of State Tax Rule

Line 1119: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

1115: ln_ovn NUMBER;
1116: ln_dummy NUMBER;
1117: ld_eff_start_date DATE;
1118: ld_eff_end_date DATE;
1119: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1120: l_fed_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
1121: l_fed_effective_start_date DATE;
1122: l_fed_effective_end_date DATE;
1123:

Line 1120: l_fed_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;

1116: ln_dummy NUMBER;
1117: ld_eff_start_date DATE;
1118: ld_eff_end_date DATE;
1119: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
1120: l_fed_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
1121: l_fed_effective_start_date DATE;
1122: l_fed_effective_end_date DATE;
1123:
1124: BEGIN