APPS.ZPB_BUSAREA_VAL dependencies on ZPB_DC_OBJECTS

Line 1882: from ZPB_DC_OBJECTS A, ZPB_ANALYSIS_CYCLES B

1878:
1879: cursor l_dc_tg_objs(p_search_str VARCHAR2, p_baID NUMBER) is
1880: select TEMPLATE_NAME, OBJECT_TYPE, A.ANALYSIS_CYCLE_ID, TARGET_OBJ_PATH
1881: into l_str2, l_str, l_acID, l_queryPath
1882: from ZPB_DC_OBJECTS A, ZPB_ANALYSIS_CYCLES B
1883: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
1884: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
1885: AND B.BUSINESS_AREA_ID = p_baID
1886: AND TARGET_OBJ_NAME = p_search_str;

Line 1891: from ZPB_DC_OBJECTS A, ZPB_ANALYSIS_CYCLES B

1887:
1888: cursor l_dc_data_objs(p_search_str VARCHAR2, p_baID NUMBER) is
1889: select TEMPLATE_NAME, OBJECT_TYPE, A.ANALYSIS_CYCLE_ID, TARGET_OBJ_PATH
1890: into l_str2, l_str, l_acID, l_queryPath
1891: from ZPB_DC_OBJECTS A, ZPB_ANALYSIS_CYCLES B
1892: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
1893: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
1894: AND B.BUSINESS_AREA_ID = p_baID
1895: AND DATAENTRY_OBJ_NAME = p_search_str;

Line 2396: from ZPB_DC_OBJECTS A, ZPB_ANALYSIS_CYCLES B

2392:
2393: cursor l_dc_tg_objs(p_search_str VARCHAR2, p_baID NUMBER) is
2394: select TEMPLATE_NAME, OBJECT_TYPE, A.ANALYSIS_CYCLE_ID, TARGET_OBJ_PATH
2395: into l_str2, l_str, l_acID, l_queryPath
2396: from ZPB_DC_OBJECTS A, ZPB_ANALYSIS_CYCLES B
2397: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
2398: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
2399: AND B.BUSINESS_AREA_ID = p_baID
2400: AND TARGET_OBJ_NAME = p_search_str;

Line 2405: from ZPB_DC_OBJECTS A, ZPB_ANALYSIS_CYCLES B

2401:
2402: cursor l_dc_data_objs(p_search_str VARCHAR2, p_baID NUMBER) is
2403: select TEMPLATE_NAME, OBJECT_TYPE, A.ANALYSIS_CYCLE_ID, TARGET_OBJ_PATH
2404: into l_str2, l_str, l_acID, l_queryPath
2405: from ZPB_DC_OBJECTS A, ZPB_ANALYSIS_CYCLES B
2406: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
2407: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
2408: AND B.BUSINESS_AREA_ID = p_baID
2409: AND DATAENTRY_OBJ_NAME = p_search_str;