APPS.HR_US_FF_UDF1 dependencies on PAY_PAYROLLS_F

Line 1397: l_payroll_id pay_payrolls_f.payroll_id%TYPE;

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

Line 2458: FROM pay_payrolls_f payroll,

2454: -- Current_pay_period (C) or Previous_pay_period(P)
2455: CURSOR csr_period_flag (p_assignment_action_id IN NUMBER) IS
2456: SELECT NVL(prl_information12 ,'P') --Defaulted to Previous
2457: ,NVL(prl_information13 ,'YTD') --defaulted to Tax Year
2458: FROM pay_payrolls_f payroll,
2459: pay_assignment_actions paa,
2460: pay_payroll_actions ppa
2461: WHERE ppa.payroll_id = payroll.payroll_id
2462: AND paa.payroll_action_id = ppa.payroll_action_id

Line 2468: l_pay_period_flag pay_payrolls_f.prl_information11%TYPE;

2464: AND NVL(ppa.date_earned,ppa.effective_date)
2465: BETWEEN payroll.effective_start_date
2466: AND payroll.effective_end_date;
2467:
2468: l_pay_period_flag pay_payrolls_f.prl_information11%TYPE;
2469: l_threshold_basis pay_payrolls_f.prl_information13%TYPE;
2470:
2471: -- Cursor to get all the informational time element entries
2472: -- Jurisdiction Code and Hours screen entry values are retrieved

Line 2469: l_threshold_basis pay_payrolls_f.prl_information13%TYPE;

2465: BETWEEN payroll.effective_start_date
2466: AND payroll.effective_end_date;
2467:
2468: l_pay_period_flag pay_payrolls_f.prl_information11%TYPE;
2469: l_threshold_basis pay_payrolls_f.prl_information13%TYPE;
2470:
2471: -- Cursor to get all the informational time element entries
2472: -- Jurisdiction Code and Hours screen entry values are retrieved
2473: -- All element entries are considered based on the start date and end date.