APPS.ZPB_BUSAREA_VAL dependencies on ZPB_COLUMNS

Line 3089: SELECT COLUMN_NAME INTO G_MEMBER_ID_COL FROM ZPB_COLUMNS

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;
3091:
3092: SELECT COLUMN_NAME INTO G_MEMBER_NAME_COL FROM ZPB_COLUMNS
3093: WHERE COLUMN_TYPE = 'LNAME_COLUMN' AND TABLE_ID = l_tableID;

Line 3092: SELECT COLUMN_NAME INTO G_MEMBER_NAME_COL FROM ZPB_COLUMNS

3088:
3089: SELECT COLUMN_NAME INTO G_MEMBER_ID_COL FROM ZPB_COLUMNS
3090: WHERE COLUMN_TYPE = 'MEMBER_COLUMN' AND TABLE_ID = l_tableID;
3091:
3092: SELECT COLUMN_NAME INTO G_MEMBER_NAME_COL FROM ZPB_COLUMNS
3093: WHERE COLUMN_TYPE = 'LNAME_COLUMN' AND TABLE_ID = l_tableID;
3094: EXCEPTION
3095: WHEN no_data_found THEN
3096: null;