DBA Data[Home] [Help]

APPS.GL_BUDGET_UTILS_PKG dependencies on GL_PERIOD_STATUSES

Line 536: FROM gl_period_statuses

532: X_Master_Budget_Version_Id NUMBER DEFAULT NULL) IS
533:
534: CURSOR chk_first_period IS
535: SELECT period_year, period_num
536: FROM gl_period_statuses
537: WHERE application_id = 101
538: AND ledger_id = X_Ledger_Id
539: AND period_num between 1 and 60
540: AND period_name = X_First_Valid_Period_Name;

Line 546: FROM gl_period_statuses

542: CURSOR chk_last_period
543: (p_first_valid_period_year NUMBER,
544: p_first_valid_period_num NUMBER) IS
545: SELECT period_year, period_num
546: FROM gl_period_statuses
547: WHERE application_id = 101
548: AND ledger_id = X_Ledger_Id
549: AND period_num between 1 and 60
550: AND period_year * 10000 + period_num >=