APPS.PAYUSUNB_PKG dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 745: pay_us_emp_fed_tax_rules_f peft

741: IF L_wage_accumulation = 'Y' THEN
742: /*Query to see if the Person has any assignments with FIT Exempt from Wage Accumulation selected */
743: SELECT count(0) INTO L_asg_count
744: FROM per_all_assignments_f paf,
745: pay_us_emp_fed_tax_rules_f peft
746: WHERE paf.person_id = L_person_id
747: AND paf.effective_end_date >= L_start_date
748: AND paf.effective_start_date <= L_as_of_date
749: AND peft.assignment_id = paf.assignment_id

Line 2219: FROM pay_us_emp_fed_tax_rules_f

2215: IN_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
2216: IN_start_date IN DATE,
2217: IN_as_of_date IN DATE) IS
2218: SELECT NVL(sui_state_code,'00')
2219: FROM pay_us_emp_fed_tax_rules_f
2220: WHERE business_group_id = IN_business_id
2221: AND assignment_id = IN_assignment_id
2222: AND effective_start_date <= IN_start_date
2223: AND effective_end_date >= IN_as_of_date;