APPS.HR_US_FF_UDF1 dependencies on PAY_PAYROLLS_F

Line 1438: l_payroll_id pay_payrolls_f.payroll_id%TYPE;

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;
1442: l_tax_unit_id NUMBER;

Line 2557: FROM pay_payrolls_f payroll,

2553: -- Current_pay_period (C) or Previous_pay_period(P)
2554: CURSOR csr_period_flag (p_assignment_action_id IN NUMBER) IS
2555: SELECT NVL(prl_information12 ,'P') --Defaulted to Previous
2556: ,NVL(prl_information13 ,'YTD') --defaulted to Tax Year
2557: FROM pay_payrolls_f payroll,
2558: pay_assignment_actions paa,
2559: pay_payroll_actions ppa
2560: WHERE ppa.payroll_id = payroll.payroll_id
2561: AND paa.payroll_action_id = ppa.payroll_action_id

Line 2567: l_pay_period_flag pay_payrolls_f.prl_information11%TYPE;

2563: AND NVL(ppa.date_earned,ppa.effective_date)
2564: BETWEEN payroll.effective_start_date
2565: AND payroll.effective_end_date;
2566:
2567: l_pay_period_flag pay_payrolls_f.prl_information11%TYPE;
2568: l_threshold_basis pay_payrolls_f.prl_information13%TYPE;
2569:
2570: -- Cursor to get all the informational time element entries
2571: -- Jurisdiction Code and Hours screen entry values are retrieved

Line 2568: l_threshold_basis pay_payrolls_f.prl_information13%TYPE;

2564: BETWEEN payroll.effective_start_date
2565: AND payroll.effective_end_date;
2566:
2567: l_pay_period_flag pay_payrolls_f.prl_information11%TYPE;
2568: l_threshold_basis pay_payrolls_f.prl_information13%TYPE;
2569:
2570: -- Cursor to get all the informational time element entries
2571: -- Jurisdiction Code and Hours screen entry values are retrieved
2572: -- All element entries are considered based on the start date and end date.