DBA Data[Home] [Help]

APPS.GL_BUDGET_UTILS_PKG dependencies on GL_PERIOD_STATUSES

Line 519: FROM gl_period_statuses

515: X_Master_Budget_Version_Id NUMBER DEFAULT NULL) IS
516:
517: CURSOR chk_first_period IS
518: SELECT period_year, period_num
519: FROM gl_period_statuses
520: WHERE application_id = 101
521: AND ledger_id = X_Ledger_Id
522: AND period_num between 1 and 60
523: AND period_name = X_First_Valid_Period_Name;

Line 529: FROM gl_period_statuses

525: CURSOR chk_last_period
526: (p_first_valid_period_year NUMBER,
527: p_first_valid_period_num NUMBER) IS
528: SELECT period_year, period_num
529: FROM gl_period_statuses
530: WHERE application_id = 101
531: AND ledger_id = X_Ledger_Id
532: AND period_num between 1 and 60
533: AND period_year * 10000 + period_num >=