APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 283: FROM pay_us_emp_fed_tax_rules_f pft

279: cp_effective_date DATE)
280: IS
281: SELECT pft.emp_fed_tax_rule_id,
282: pft.object_version_number
283: FROM pay_us_emp_fed_tax_rules_f pft
284: WHERE pft.assignment_id = cp_assignment_id
285: AND cp_effective_date BETWEEN pft.effective_start_date
286: AND pft.effective_end_date;
287:

Line 373: ln_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

369: lb_spp_delete_warning BOOLEAN;
370: lv_entries_changed_warning VARCHAR2(10);
371: lb_tax_dist_changed_warning BOOLEAN;
372:
373: ln_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
374: ln_ft_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
375: ln_emp_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
376: ln_st_object_version_number pay_us_emp_state_tax_rules_f.object_version_number%TYPE;
377:

Line 374: ln_ft_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;

370: lv_entries_changed_warning VARCHAR2(10);
371: lb_tax_dist_changed_warning BOOLEAN;
372:
373: ln_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
374: ln_ft_object_version_number pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
375: ln_emp_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
376: ln_st_object_version_number pay_us_emp_state_tax_rules_f.object_version_number%TYPE;
377:
378: FUNCTION value_changed(p_value VARCHAR2,