APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_ALL_PAYROLLS_F

Line 2838: l_payroll_id pay_all_payrolls_f.payroll_id%type;

2834: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
2835: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
2836: l_accrual_category pay_accrual_plans.accrual_category%type;
2837: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
2838: l_payroll_id pay_all_payrolls_f.payroll_id%type;
2839: l_business_group_id NUMBER;
2840: l_effective_date DATE;
2841: l_annual_leave_balance NUMBER;
2842: l_ovn NUMBER;

Line 3925: FROM pay_all_payrolls_f

3921:
3922: /* cursor to get the payroll details */
3923: CURSOR csr_payroll_details (l_payroll_id NUMBER) IS
3924: SELECT payroll_name , period_type
3925: FROM pay_all_payrolls_f
3926: WHERE payroll_id = l_payroll_id ;
3927: --------------
3928:
3929: /* Cursor to get the Work Title from the assignment */