DBA Data[Home] [Help]

APPS.BSC_TAB_VIEW_LABELS_PKG dependencies on BSC_TABS_B

Line 484: WHERE TAB_ID = (SELECT TAB_ID FROM BSC_TABS_B WHERE SHORT_NAME = X_SHORT_NAME)

480: ) IS
481: L_SHORT NUMBER := -1;
482: BEGIN
483: SELECT COUNT(*) INTO L_SHORT FROM BSC_TAB_VIEW_LABELS_B
484: WHERE TAB_ID = (SELECT TAB_ID FROM BSC_TABS_B WHERE SHORT_NAME = X_SHORT_NAME)
485: AND TAB_VIEW_ID = X_TAB_VIEW_ID
486: AND LABEL_ID = X_LABEL_ID;
487: IF (L_SHORT > 0) THEN
488: UPDATE BSC_TAB_VIEW_LABELS_B

Line 490: WHERE TAB_ID = (SELECT TAB_ID FROM BSC_TABS_B WHERE SHORT_NAME = X_SHORT_NAME)

486: AND LABEL_ID = X_LABEL_ID;
487: IF (L_SHORT > 0) THEN
488: UPDATE BSC_TAB_VIEW_LABELS_B
489: SET LINK_ID = X_MENU_ID
490: WHERE TAB_ID = (SELECT TAB_ID FROM BSC_TABS_B WHERE SHORT_NAME = X_SHORT_NAME)
491: AND TAB_VIEW_ID = X_TAB_VIEW_ID
492: AND LABEL_ID = X_LABEL_ID
493: AND LABEL_TYPE = 2;
494: -- AND LAST_UPDATE_DATE <= X_LAST_UPDATE_DATE;