APPS.BSC_DATASETS_PUB dependencies on BSC_SYS_DATASETS_VL

Line 1528: FROM bsc_sys_datasets_vl

1524: p_DataSet_Id IN NUMBER
1525: ) RETURN VARCHAR2 IS
1526: CURSOR c_dataset_name IS
1527: SELECT name
1528: FROM bsc_sys_datasets_vl
1529: WHERE dataset_id = p_DataSet_Id;
1530: l_Name bsc_sys_datasets_vl.name%TYPE := NULL;
1531: BEGIN
1532:

Line 1530: l_Name bsc_sys_datasets_vl.name%TYPE := NULL;

1526: CURSOR c_dataset_name IS
1527: SELECT name
1528: FROM bsc_sys_datasets_vl
1529: WHERE dataset_id = p_DataSet_Id;
1530: l_Name bsc_sys_datasets_vl.name%TYPE := NULL;
1531: BEGIN
1532:
1533: OPEN c_dataset_name;
1534: FETCH c_dataset_name INTO l_Name;

Line 1548: FROM bsc_sys_datasets_vl

1544: p_DataSet_Id IN NUMBER
1545: ) RETURN VARCHAR2 IS
1546: CURSOR c_dataset_source IS
1547: SELECT NVL(source,'BSC')
1548: FROM bsc_sys_datasets_vl
1549: WHERE dataset_id = p_DataSet_Id;
1550: l_Source bsc_sys_datasets_vl.source%TYPE;
1551: BEGIN
1552:

Line 1550: l_Source bsc_sys_datasets_vl.source%TYPE;

1546: CURSOR c_dataset_source IS
1547: SELECT NVL(source,'BSC')
1548: FROM bsc_sys_datasets_vl
1549: WHERE dataset_id = p_DataSet_Id;
1550: l_Source bsc_sys_datasets_vl.source%TYPE;
1551: BEGIN
1552:
1553: OPEN c_dataset_source;
1554: FETCH c_dataset_source INTO l_Source;

Line 1592: bis_indicators i,bsc_sys_datasets_vl d

1588: ),
1589: (SELECT ff.user_function_name FROM fnd_form_functions_vl ff WHERE ff.function_name = i.function_name)
1590: ) , p_No_Report_Message) || ']' name
1591: FROM
1592: bis_indicators i,bsc_sys_datasets_vl d
1593: WHERE
1594: i.dataset_id = d.dataset_id AND
1595: d.source = 'PMF' AND
1596: i.dataset_id = p_DataSet_Id

Line 1601: bsc_sys_datasets_vl d

1597: UNION
1598: SELECT
1599: d.Name
1600: FROM
1601: bsc_sys_datasets_vl d
1602: WHERE
1603: d.dataset_id = p_DataSet_Id AND
1604: NVL(d.source,'BSC') <> 'PMF';
1605: