APPS.BSC_PMF_UI_API_PUB dependencies on BSC_SYS_DATASETS_B

Line 675: BSC_SYS_DATASETS_B B

671: SELECT A.MEASURE_ID, B.DATASET_ID
672: INTO l_Measure_Id,
673: l_dataset_id
674: FROM BSC_SYS_MEASURES A,
675: BSC_SYS_DATASETS_B B
676: WHERE A.SHORT_NAME = l_Dataset_Rec.Bsc_Measure_Short_Name
677: AND A.SOURCE = 'PMF'
678: AND A.MEASURE_ID = B.MEASURE_ID1;
679:

Line 910: from BSC_SYS_DATASETS_B a,

906: -- Get the Dataset Id for the current PMF Measure. This Dataset Id was set in the
907: -- Create_Bsc_Dataset procedure.
908: select distinct a.dataset_id
909: into g_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id
910: from BSC_SYS_DATASETS_B a,
911: BSC_SYS_MEASURES b
912: where upper(b.short_name) = upper(p_Bsc_Pmf_Ui_Rec.Measure_Short_Name)
913: and a.measure_id1 = b.measure_id
914: and rownum < 2;