APPS.PAY_US_FS_UPD_PKG dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 32: from pay_us_emp_state_tax_rules_f taxrule,

28: to_char(taxrule.effective_end_date, 'DD-MON-YYYY'),
29: taxrule.filing_status_code ,
30: taxrule.business_group_id ,
31: p_session_id, p_bug_number
32: from pay_us_emp_state_tax_rules_f taxrule,
33: per_assignments_f paf,
34: per_all_people_f ppf
35: where taxrule.state_code = p_pest_state_code
36: and taxrule.filing_status_code = p_pest_fs_code

Line 57: update pay_us_emp_state_tax_rules_f

53: null;
54: end;
55:
56:
57: update pay_us_emp_state_tax_rules_f
58: set filing_status_code = p_new_fs_code
59: where state_code = p_pest_state_code
60: and filing_status_code = p_pest_fs_code
61: and emp_state_tax_rule_id = p_pest_id;

Line 72: from pay_us_emp_state_tax_rules_f

68:
69: IS
70: CURSOR filing_status_cur IS
71: select state_code, filing_status_code, emp_state_tax_rule_id
72: from pay_us_emp_state_tax_rules_f
73: where emp_state_tax_rule_id between
74: p_tax_rule_id_start and p_tax_rule_id_end ;
75:
76: filing_status_rec filing_status_cur%ROWTYPE;