APPS.PAY_DK_ARCHIVE dependencies on PAY_ALL_PAYROLLS_F

Line 1882: l_payroll_id pay_all_payrolls_f.payroll_id%type;

1878: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
1879: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
1880: l_accrual_category pay_accrual_plans.accrual_category%type;
1881: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
1882: l_payroll_id pay_all_payrolls_f.payroll_id%type;
1883: l_business_group_id NUMBER;
1884: l_effective_date DATE;
1885: l_annual_leave_balance NUMBER;
1886: l_ovn NUMBER;

Line 2730: FROM pay_all_payrolls_f

2726:
2727: /* cursor to get the payroll details */
2728: CURSOR csr_payroll_details (l_payroll_id NUMBER) IS
2729: SELECT payroll_name , period_type
2730: FROM pay_all_payrolls_f
2731: WHERE payroll_id = l_payroll_id ;
2732: --------------
2733:
2734: l_actual_termination_date PER_PERIODS_OF_SERVICE.ACTUAL_TERMINATION_DATE%TYPE;