APPS.GMS_REPORT_SF269 dependencies on GL_PERIOD_STATUSES

Line 361: FROM gl_period_statuses

357: x_period_end_date DATE ; -- Bug 2660430
358:
359: CURSOR c_period_dates IS -- Bug 2660430, Added
360: SELECT start_date, end_date
361: FROM gl_period_statuses
362: WHERE period_name = (SELECT pa_accum_utils.Get_current_gl_period FROM DUAL)
363: AND adjustment_period_flag = 'N'
364: AND application_id = 101
365: AND set_of_books_id = l_set_of_books_id ;

Line 396: gl_period_statuses gps

392: /* Select sum(nvl(acct_burdened_cost,0)) burdened_cost
393: --sum(nvl(tot_cmt_burdened_cost,0)) burdened_cost -- 11i changes
394: into l_cum_unliquid_obligation
395: from pa_commitment_txns_v cmt,
396: gl_period_statuses gps
397: where cmt.gl_period = gps.period_name
398: and cmt.original_txn_reference1 = to_char(X_Award_Id)
399: and gps.adjustment_period_flag = 'N'
400: and gps.application_id = 101