APPS.ZPB_BUSAREA_VAL dependencies on ZPB_SOLVE_OUTPUT_SELECTIONS

Line 1909: from ZPB_SOLVE_OUTPUT_SELECTIONS A, ZPB_ANALYSIS_CYCLES B

1905:
1906: cursor l_output_sel(p_search_str VARCHAR2, p_baID NUMBER) is
1907: select SELECTION_NAME, SELECTION_PATH, A.ANALYSIS_CYCLE_ID, B.NAME
1908: into l_str, l_queryPath, l_acID, l_bpName
1909: from ZPB_SOLVE_OUTPUT_SELECTIONS A, ZPB_ANALYSIS_CYCLES B
1910: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
1911: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
1912: AND B.BUSINESS_AREA_ID = p_baID
1913: AND SELECTION_NAME = p_search_str;

Line 2423: from ZPB_SOLVE_OUTPUT_SELECTIONS A, ZPB_ANALYSIS_CYCLES B

2419:
2420: cursor l_output_sel(p_search_str VARCHAR2, p_baID NUMBER) is
2421: select SELECTION_NAME, SELECTION_PATH, A.ANALYSIS_CYCLE_ID, DIMENSION, B.NAME
2422: into l_str, l_queryPath, l_acID, l_current_dim, l_bpName
2423: from ZPB_SOLVE_OUTPUT_SELECTIONS A, ZPB_ANALYSIS_CYCLES B
2424: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
2425: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
2426: AND B.BUSINESS_AREA_ID = p_baID
2427: AND SELECTION_NAME = p_search_str;