APPS.BSC_PMF_UI_API_PUB dependencies on BSC_SYS_MEASURES

Line 674: FROM BSC_SYS_MEASURES A,

670:
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;

Line 777: l_measure_col BSC_SYS_MEASURES.MEASURE_COL%TYPE;

773: ) is
774:
775: --Bug 2677766
776: l_bsc_format_id number;
777: l_measure_col BSC_SYS_MEASURES.MEASURE_COL%TYPE;
778: begin
779:
780: g_Bsc_Dataset_Rec.Bsc_Measure_Short_Name := p_Bsc_Pmf_Ui_Rec.Measure_Short_Name;
781: g_Bsc_Dataset_Rec.Bsc_Measure_Operation := 'SUM';

Line 911: BSC_SYS_MEASURES b

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;
915: