APPS.MRP_PARAMETER_MRPFSETA dependencies on GL_PERIODS

Line 73: from gl_periods

69: return FALSE;
70: else
71: select distinct period_type
72: into l_period_type
73: from gl_periods
74: where period_set_name in (select period_set_name
75: from gl_sets_of_books gl,
76: org_organization_definitions org
77: where org.set_of_books_id = gl.set_of_books_id

Line 207: FROM gl_periods;

203: PROCEDURE MRPFSETA_Parameter_PrintPer(
204: param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type, --2663505
205: i IN NUMBER) IS
206: CURSOR c_period IS SELECT distinct period_type name, period_type id
207: FROM gl_periods;
208: BEGIN
209: param(i).Label := FND_MESSAGE.get_string( 'MRP', 'MRP_PERIOD_LABEL');
210: param(i).Value := htf.formSelectOpen( 'P_PERIOD' );
211: FOR c1 in c_period LOOP

Line 313: SELECT distinct period_type name from gl_periods;

309: CURSOR c_business_plans IS
310: select plan_id, name from bisbv_business_plans;
311:
312: CURSOR c_period_types IS
313: SELECT distinct period_type name from gl_periods;
314:
315: CURSOR c_forecast IS
316: SELECT distinct forecast_designator name from mrp_forecast_designators
317: where forecast_set IS null