DBA Data[Home] [Help]

APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 294: FROM pay_us_emp_state_tax_rules_f pst,

290: cp_state_abbrev VARCHAR2)
291: IS
292: SELECT pst.emp_state_tax_rule_id,
293: pst.object_version_number
294: FROM pay_us_emp_state_tax_rules_f pst,
295: pay_us_states pus
296: WHERE pst.assignment_id = cp_assignment_id
297: AND cp_effective_date BETWEEN pst.effective_start_date
298: AND pst.effective_end_date

Line 375: ln_emp_state_tax_rule_id pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;

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,
379: p_default_value VARCHAR2)

Line 376: ln_st_object_version_number pay_us_emp_state_tax_rules_f.object_version_number%TYPE;

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,
379: p_default_value VARCHAR2)
380: