APPS.ZPB_BUSAREA_VAL dependencies on ZPB_DATA_INITIALIZATION_DEFS

Line 1918: from ZPB_DATA_INITIALIZATION_DEFS A, ZPB_ANALYSIS_CYCLES B

1914:
1915: cursor l_init_source(p_search_str VARCHAR2, p_baID NUMBER) is
1916: select SOURCE_QUERY_NAME, QUERY_PATH, MEMBER, A.ANALYSIS_CYCLE_ID
1917: into l_str, l_queryPath, l_memberID, l_acID
1918: from ZPB_DATA_INITIALIZATION_DEFS A, ZPB_ANALYSIS_CYCLES B
1919: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
1920: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
1921: AND B.BUSINESS_AREA_ID = p_baID
1922: AND SOURCE_QUERY_NAME = p_search_str;

Line 1927: from ZPB_DATA_INITIALIZATION_DEFS A, ZPB_ANALYSIS_CYCLES B

1923:
1924: cursor l_init_target(p_search_str VARCHAR2, p_baID NUMBER) is
1925: select TARGET_QUERY_NAME, QUERY_PATH, MEMBER, A.ANALYSIS_CYCLE_ID
1926: into l_str, l_queryPath, l_memberID, l_acID
1927: from ZPB_DATA_INITIALIZATION_DEFS A, ZPB_ANALYSIS_CYCLES B
1928: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
1929: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
1930: AND B.BUSINESS_AREA_ID = p_baID
1931: AND TARGET_QUERY_NAME = p_search_str;

Line 2432: from ZPB_DATA_INITIALIZATION_DEFS A, ZPB_ANALYSIS_CYCLES B

2428:
2429: cursor l_init_source(p_search_str VARCHAR2, p_baID NUMBER) is
2430: select SOURCE_QUERY_NAME, QUERY_PATH, MEMBER, A.ANALYSIS_CYCLE_ID
2431: into l_str, l_queryPath, l_memberID, l_acID
2432: from ZPB_DATA_INITIALIZATION_DEFS A, ZPB_ANALYSIS_CYCLES B
2433: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
2434: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
2435: AND B.BUSINESS_AREA_ID = p_baID
2436: AND SOURCE_QUERY_NAME = p_search_str;

Line 2441: from ZPB_DATA_INITIALIZATION_DEFS A, ZPB_ANALYSIS_CYCLES B

2437:
2438: cursor l_init_target(p_search_str VARCHAR2, p_baID NUMBER) is
2439: select TARGET_QUERY_NAME, QUERY_PATH, MEMBER, A.ANALYSIS_CYCLE_ID
2440: into l_str, l_queryPath, l_memberID, l_acID
2441: from ZPB_DATA_INITIALIZATION_DEFS A, ZPB_ANALYSIS_CYCLES B
2442: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
2443: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
2444: AND B.BUSINESS_AREA_ID = p_baID
2445: AND TARGET_QUERY_NAME = p_search_str;