APPS.PAY_DK_ARCHIVE dependencies on PAY_ALL_PAYROLLS_F

Line 1910: l_payroll_id pay_all_payrolls_f.payroll_id%type;

1906: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
1907: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
1908: l_accrual_category pay_accrual_plans.accrual_category%type;
1909: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
1910: l_payroll_id pay_all_payrolls_f.payroll_id%type;
1911: l_business_group_id NUMBER;
1912: l_effective_date DATE;
1913: l_annual_leave_balance NUMBER;
1914: l_ovn NUMBER;

Line 3172: FROM pay_all_payrolls_f

3168:
3169: /* cursor to get the payroll details */
3170: CURSOR csr_payroll_details (l_payroll_id NUMBER) IS
3171: SELECT payroll_name , period_type
3172: FROM pay_all_payrolls_f
3173: WHERE payroll_id = l_payroll_id ;
3174: --------------
3175:
3176: l_actual_termination_date PER_PERIODS_OF_SERVICE.ACTUAL_TERMINATION_DATE%TYPE;