DBA Data[Home] [Help]

APPS.ZPB_BUSAREA_VAL dependencies on ZPB_TABLES

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;