APPS.PAY_US_EMP_BALADJ_CLEANUP dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 781: pay_us_emp_state_tax_rules_f pest,

777: paa.tax_unit_id,
778: paa.assignment_id,
779: ppa.effective_date
780: from per_assignments_f paf,
781: pay_us_emp_state_tax_rules_f pest,
782: pay_assignment_actions paa,
783: pay_payroll_actions ppa
784: where paf.person_id between cp_start_person_id
785: and cp_end_person_id

Line 820: from pay_us_emp_state_tax_rules_f pest

816:
817: cursor c_get_jurisduction_code(cp_assignment_id in number
818: ,cp_effective_date in date) is
819: select distinct state_code
820: from pay_us_emp_state_tax_rules_f pest
821: where pest.assignment_id = cp_assignment_id
822: and cp_effective_date between pest.effective_Start_date
823: and pest.effective_end_Date;
824:

Line 1410: from pay_us_emp_state_tax_rules_f st

1406: cursor csr_chk_state(cp_assignment_id in number
1407: ,cp_effective_date in date
1408: ,cp_where_state_code in varchar2) IS
1409: select st.state_code, st.jurisdiction_code
1410: from pay_us_emp_state_tax_rules_f st
1411: where st.assignment_id = cp_assignment_id
1412: and st.state_code like cp_where_state_code
1413: and cp_effective_date between st.effective_start_date
1414: and st.effective_end_date;