APPS.ZPB_BUSAREA_VAL dependencies on ZPB_TASK_PARAMETERS

Line 2039: ZPB_TASK_PARAMETERS C,

2035: nvl (D.INSTANCE_DESCRIPTION, B.NAME) NAME
2036: into l_str2, l_taskID, l_acID, l_str
2037: from ZPB_ANALYSIS_CYCLE_TASKS A,
2038: ZPB_ANALYSIS_CYCLES B,
2039: ZPB_TASK_PARAMETERS C,
2040: ZPB_ANALYSIS_CYCLE_INSTANCES D
2041: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
2042: and B.STATUS_CODE <> 'MARKED_FOR_DELETION'
2043: and B.BUSINESS_AREA_ID = p_business_area

Line 2052: FROM ZPB_TASK_PARAMETERS

2048: and A.ANALYSIS_CYCLE_ID = D.INSTANCE_AC_ID(+);
2049:
2050: SELECT value
2051: INTO l_queryPath
2052: FROM ZPB_TASK_PARAMETERS
2053: WHERE name = 'QUERY_OBJECT_PATH'
2054: AND TASK_ID = l_taskID;
2055:
2056: IF(l_queryErrorType = 'F') THEN

Line 2577: ZPB_TASK_PARAMETERS C,

2573: nvl (D.INSTANCE_DESCRIPTION, B.NAME) NAME
2574: into l_str2, l_taskID, l_acID, l_str
2575: from ZPB_ANALYSIS_CYCLE_TASKS A,
2576: ZPB_ANALYSIS_CYCLES B,
2577: ZPB_TASK_PARAMETERS C,
2578: ZPB_ANALYSIS_CYCLE_INSTANCES D
2579: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
2580: and B.STATUS_CODE <> 'MARKED_FOR_DELETION'
2581: and B.BUSINESS_AREA_ID = p_business_area

Line 2590: FROM ZPB_TASK_PARAMETERS

2586: and A.ANALYSIS_CYCLE_ID = D.INSTANCE_AC_ID(+);
2587:
2588: SELECT value
2589: INTO l_queryPath
2590: FROM ZPB_TASK_PARAMETERS
2591: WHERE name = 'QUERY_OBJECT_PATH'
2592: AND TASK_ID = l_taskID;
2593:
2594: IF (instr (each.object_name, 'LOAD_DATA') > 0) then

Line 2608: FROM ZPB_TASK_PARAMETERS

2604:
2605: ELSE
2606: SELECT value
2607: INTO l_current_dim
2608: FROM ZPB_TASK_PARAMETERS
2609: WHERE name = 'EXCEPTION_DIMENSION'
2610: AND TASK_ID = l_taskID;
2611: if(l_rem_def_hier_dim = l_current_dim) then
2612: l_queryErrorType := 'F';