APPS.BSC_SCORECARD_PUB dependencies on BSC_TABS_B

Line 75: FROM BSC_TABS_B;

71: -- Get the next id available for the current Tab.
72: -- Bug #3236356
73: SELECT (NVL(MAX(TAB_ID), 0) + 1)
74: INTO l_Bsc_Tab_Entity_Rec.Bsc_Tab_Id
75: FROM BSC_TABS_B;
76:
77: --DBMS_OUTPUT.PUT_LINE('tab _id ==============' || l_Bsc_Tab_Entity_Rec.Bsc_Tab_Id);
78:
79: -- If tab name is null then assign default name.

Line 87: FROM BSC_TABS_B;

83:
84: -- Bug #3236356
85: SELECT (NVL(MAX(TAB_INDEX), 0) + 1)
86: INTO l_Bsc_Tab_Entity_Rec.Bsc_Tab_Index
87: FROM BSC_TABS_B;
88: -- The Tab needs an Index (location within BSC Tabs) get the next index.
89:
90:
91:

Line 574: l_Tab_Short_Name BSC_TABS_B.SHORT_NAME%TYPE := NULL;

570:
571: l_Bsc_Tab_Entity_Rec BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec;
572: l_Responsibility_Key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;
573: l_Comma_Sep_Resp_Key VARCHAR2(32000):= NULL;
574: l_Tab_Short_Name BSC_TABS_B.SHORT_NAME%TYPE := NULL;
575:
576: BEGIN
577: FND_MSG_PUB.Initialize;
578: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 584: FROM BSC_TABS_B T

580:
581: BEGIN
582: SELECT T.SHORT_NAME
583: INTO l_Tab_Short_Name
584: FROM BSC_TABS_B T
585: WHERE T.TAB_ID = l_Bsc_Tab_Entity_Rec.Bsc_Tab_Id;
586: EXCEPTION
587: WHEN NO_DATA_FOUND THEN
588: l_Tab_Short_Name := NULL;

Line 1058: FROM bsc_tabs_b

1054: l_parent_tab_id1 := l_parent_tab_id;
1055:
1056: SELECT parent_tab_id
1057: INTO l_parent_tab_id
1058: FROM bsc_tabs_b
1059: WHERE tab_id = l_parent_tab_id1;
1060:
1061: END LOOP;
1062: