APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_ALL_PAYROLLS_F

Line 2849: l_payroll_id pay_all_payrolls_f.payroll_id%type;

2845: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
2846: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
2847: l_accrual_category pay_accrual_plans.accrual_category%type;
2848: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
2849: l_payroll_id pay_all_payrolls_f.payroll_id%type;
2850: l_business_group_id NUMBER;
2851: l_effective_date DATE;
2852: l_annual_leave_balance NUMBER;
2853: l_ovn NUMBER;

Line 3936: FROM pay_all_payrolls_f

3932:
3933: /* cursor to get the payroll details */
3934: CURSOR csr_payroll_details (l_payroll_id NUMBER) IS
3935: SELECT payroll_name , period_type
3936: FROM pay_all_payrolls_f
3937: WHERE payroll_id = l_payroll_id ;
3938: --------------
3939:
3940: /* Cursor to get the Work Title from the assignment */