APPS.BSC_ANALYSIS_OPTION_PVT dependencies on BSC_KPI_ANALYSIS_OPTIONS_VL

Line 24: | BSC_KPI_ANALYSIS_OPTIONS_VL in select statement |

20: | |
21: | History: |
22: | 05-MAR-2003 ADEULGAO fixed MLS issue bug#2721899 |
23: | changed BSC_KPI_ANALYSIS_OPTIONS_TL to |
24: | BSC_KPI_ANALYSIS_OPTIONS_VL in select statement |
25: | 13-MAY-2003 PWALI Bug #2942895, SQL BIND COMPLIANCE |
26: | |
27: | 08-SEP-2003 kyadamak FIX THE BUG 3124010 |
28: | 14-NOV-2003 PAJOHRI Bug #3248729 |

Line 969: from BSC_KPI_ANALYSIS_OPTIONS_VL

965: ,x_Anal_Opt_Rec.Bsc_User_Level2_Default
966: ,x_Anal_Opt_Rec.Bsc_Option_Name
967: ,x_Anal_Opt_Rec.Bsc_Option_Help
968: ,x_Anal_Opt_Rec.Bsc_Option_Short_Name
969: from BSC_KPI_ANALYSIS_OPTIONS_VL
970: where indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
971: and analysis_group_id = p_Anal_Opt_Rec.Bsc_Analysis_Group_Id
972: and option_id = p_Anal_Opt_Rec.Bsc_Analysis_Option_Id
973: and parent_option_id = p_Anal_Opt_Rec.Bsc_Parent_Option_Id;

Line 996: from BSC_KPI_ANALYSIS_OPTIONS_VL

992: ,x_Anal_Opt_Rec.Bsc_User_Level2_Default
993: ,x_Anal_Opt_Rec.Bsc_Option_Name
994: ,x_Anal_Opt_Rec.Bsc_Option_Help
995: ,x_Anal_Opt_Rec.Bsc_Option_Short_Name
996: from BSC_KPI_ANALYSIS_OPTIONS_VL
997: where indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
998: and analysis_group_id = p_Anal_Opt_Rec.Bsc_Analysis_Group_Id
999: and option_id = p_Anal_Opt_Rec.Bsc_Analysis_Option_Id
1000: and parent_option_id = p_Anal_Opt_Rec.Bsc_Parent_Option_Id

Line 1025: from BSC_KPI_ANALYSIS_OPTIONS_VL

1021: ,x_Anal_Opt_Rec.Bsc_User_Level2_Default
1022: ,x_Anal_Opt_Rec.Bsc_Option_Name
1023: ,x_Anal_Opt_Rec.Bsc_Option_Help
1024: ,x_Anal_Opt_Rec.Bsc_Option_Short_Name
1025: from BSC_KPI_ANALYSIS_OPTIONS_VL
1026: where indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
1027: and analysis_group_id = p_Anal_Opt_Rec.Bsc_Analysis_Group_Id
1028: and option_id = p_Anal_Opt_Rec.Bsc_Analysis_Option_Id;
1029: