APPS.HR_US_FF_UDF1 dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 1428: FROM pay_us_emp_fed_tax_rules_f fed,

1424:
1425: -- Get flag to determine assignment has only IT time.
1426: CURSOR csr_use_it_flag (p_assignment_action_id IN NUMBER) IS
1427: SELECT NVL(fed.fed_information1,'N'),paa.assignment_id
1428: FROM pay_us_emp_fed_tax_rules_f fed,
1429: pay_assignment_actions paa,
1430: pay_payroll_actions ppa
1431: WHERE paa.assignment_id = fed.assignment_id
1432: AND paa.assignment_action_id = p_assignment_action_id

Line 1437: l_use_it_flag pay_us_emp_fed_tax_rules_f.fed_information1%TYPE;

1433: AND paa.payroll_action_id = ppa.payroll_action_id
1434: AND NVL(ppa.date_earned,ppa.effective_date)
1435: BETWEEN fed.effective_start_date AND fed.effective_end_date;
1436:
1437: l_use_it_flag pay_us_emp_fed_tax_rules_f.fed_information1%TYPE;
1438: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
1439: l_time_period_id pay_payroll_actions.time_period_id%TYPE;
1440: l_return_flag VARCHAR2(2);
1441: l_business_group_id NUMBER;