DBA Data[Home] [Help]

APPS.ZPB_BUSAREA_VAL dependencies on ZPB_ANALYSIS_CYCLE_TASKS

Line 2037: from ZPB_ANALYSIS_CYCLE_TASKS A,

2033: l_num := to_number(substr(each.folder_name, 3));
2034: select A.TASK_NAME, A.TASK_ID, A.ANALYSIS_CYCLE_ID,
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

Line 2575: from ZPB_ANALYSIS_CYCLE_TASKS A,

2571: l_num := to_number(substr(each.folder_name, 3));
2572: select A.TASK_NAME, A.TASK_ID, A.ANALYSIS_CYCLE_ID,
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