DBA Data[Home] [Help]

APPS.IGC_CC_OPEN_INTERFACE_PKG dependencies on PA_TASKS

Line 4128: -- Performance Tuning, Replaced pa_tasks_expend_v

4124: l_error_message,
4125: P_X_Error_Status);
4126: ELSIF P_Project_Id IS NOT NULL AND P_Task_Id IS NOT NULL THEN
4127: BEGIN
4128: -- Performance Tuning, Replaced pa_tasks_expend_v
4129: -- FROM pa_tasks_expend_v
4130: SELECT task_id INTO l_task_id
4131: FROM pa_tasks
4132: WHERE task_id = P_Task_Id

Line 4129: -- FROM pa_tasks_expend_v

4125: P_X_Error_Status);
4126: ELSIF P_Project_Id IS NOT NULL AND P_Task_Id IS NOT NULL THEN
4127: BEGIN
4128: -- Performance Tuning, Replaced pa_tasks_expend_v
4129: -- FROM pa_tasks_expend_v
4130: SELECT task_id INTO l_task_id
4131: FROM pa_tasks
4132: WHERE task_id = P_Task_Id
4133: AND project_id = P_Project_Id;

Line 4131: FROM pa_tasks

4127: BEGIN
4128: -- Performance Tuning, Replaced pa_tasks_expend_v
4129: -- FROM pa_tasks_expend_v
4130: SELECT task_id INTO l_task_id
4131: FROM pa_tasks
4132: WHERE task_id = P_Task_Id
4133: AND project_id = P_Project_Id;
4134: EXCEPTION WHEN NO_DATA_FOUND THEN
4135: l_error_message := NULL;