APPS.HR_US_FF_UDF1 dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 1387: FROM pay_us_emp_fed_tax_rules_f fed,

1383:
1384: -- Get flag to determine assignment has only IT time.
1385: CURSOR csr_use_it_flag (p_assignment_action_id IN NUMBER) IS
1386: SELECT NVL(fed.fed_information1,'N'),paa.assignment_id
1387: FROM pay_us_emp_fed_tax_rules_f fed,
1388: pay_assignment_actions paa,
1389: pay_payroll_actions ppa
1390: WHERE paa.assignment_id = fed.assignment_id
1391: AND paa.assignment_action_id = p_assignment_action_id

Line 1396: l_use_it_flag pay_us_emp_fed_tax_rules_f.fed_information1%TYPE;

1392: AND paa.payroll_action_id = ppa.payroll_action_id
1393: AND NVL(ppa.date_earned,ppa.effective_date)
1394: BETWEEN fed.effective_start_date AND fed.effective_end_date;
1395:
1396: l_use_it_flag pay_us_emp_fed_tax_rules_f.fed_information1%TYPE;
1397: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
1398: l_time_period_id pay_payroll_actions.time_period_id%TYPE;
1399: l_return_flag VARCHAR2(2);
1400: l_business_group_id NUMBER;