DBA Data[Home] [Help]

APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on GL_PERIOD_STATUSES

Line 45: FROM gl_period_statuses

41: --Added by dpsingh for SLA Uptake (Bug 5707866)
42: -- Cursor to select accrual reversal date for an accrual transaction
43: CURSOR get_accrual_reversal_date(p_ledger_id NUMBER,p_accrual_date Date) IS
44: SELECT end_date +1 accrual_reversal_date
45: FROM gl_period_statuses
46: WHERE application_id = 540
47: AND set_of_books_id =p_ledger_id
48: AND p_accrual_date BETWEEN start_date AND end_date;
49: