APPS.BSC_BIS_KPI_CRUD_PUB dependencies on BSC_TAB_IND_GROUPS_VL

Line 7375: l_kpiGroup_id bsc_tab_ind_groups_vl.IND_GROUP_ID%TYPE;

7371: ,x_msg_count OUT NOCOPY NUMBER
7372: ,x_msg_data OUT NOCOPY VARCHAR2
7373: ) IS
7374:
7375: l_kpiGroup_id bsc_tab_ind_groups_vl.IND_GROUP_ID%TYPE;
7376:
7377: CURSOR c_get_kpiGroup IS
7378: SELECT ind_group_id FROM bsc_tab_ind_groups_vl
7379: WHERE tab_id = p_tabId;

Line 7378: SELECT ind_group_id FROM bsc_tab_ind_groups_vl

7374:
7375: l_kpiGroup_id bsc_tab_ind_groups_vl.IND_GROUP_ID%TYPE;
7376:
7377: CURSOR c_get_kpiGroup IS
7378: SELECT ind_group_id FROM bsc_tab_ind_groups_vl
7379: WHERE tab_id = p_tabId;
7380:
7381: BEGIN
7382:

Line 11551: l_obj_grp_name BSC_TAB_IND_GROUPS_VL.name%TYPE;

11547: (
11548: p_obj_grp_id NUMBER
11549: )
11550: RETURN VARCHAR2 IS
11551: l_obj_grp_name BSC_TAB_IND_GROUPS_VL.name%TYPE;
11552: BEGIN
11553: IF(p_obj_grp_id IS NOT NULL)THEN
11554:
11555: SELECT name

Line 11557: FROM bsc_tab_ind_groups_vl

11553: IF(p_obj_grp_id IS NOT NULL)THEN
11554:
11555: SELECT name
11556: INTO l_obj_grp_name
11557: FROM bsc_tab_ind_groups_vl
11558: WHERE ind_group_id = p_obj_grp_id
11559: AND tab_id = -1;
11560:
11561: END IF;