Line 3086: SELECT table_name INTO G_LINE_DIM_TABLE_NAME FROM zpb_tables
3082: SELECT SHAR_TABLE_ID INTO l_tableID FROM zpb_dimensions
3083: WHERE BUS_AREA_ID = l_ba_id
3084: AND dim_type = 'LINE';
3085: 3086: SELECT table_name INTO G_LINE_DIM_TABLE_NAME FROM zpb_tables 3087: WHERE TABLE_ID = l_tableID;
3088:
3089: SELECT COLUMN_NAME INTO G_MEMBER_ID_COL FROM ZPB_COLUMNS
3090: WHERE COLUMN_TYPE = 'MEMBER_COLUMN' AND TABLE_ID = l_tableID;