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 213: FROM gl_periods;

209: PROCEDURE MRPFSETA_Parameter_PrintPer(
210: -- param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type, --2663505
211: i IN NUMBER) IS
212: CURSOR c_period IS SELECT distinct period_type name, period_type id
213: FROM gl_periods;
214: BEGIN
215: /*
216: param(i).Label := FND_MESSAGE.get_string( 'MRP', 'MRP_PERIOD_LABEL');
217: param(i).Value := htf.formSelectOpen( 'P_PERIOD' );

Line 324: SELECT distinct period_type name from gl_periods;

320: CURSOR c_business_plans IS
321: select plan_id, name from bisbv_business_plans;
322: */
323: CURSOR c_period_types IS
324: SELECT distinct period_type name from gl_periods;
325:
326: CURSOR c_forecast IS
327: SELECT distinct forecast_designator name from mrp_forecast_designators
328: where forecast_set IS null