APPS.PATC dependencies on PA_TASKS

Line 325: pa_tasks t

321: , pt.project_type_class_code p_proj_typ_class_code -- PA.L Retirement Cost Processing
322: , nvl(p.assign_precedes_task, 'N') p_assign_precedes_task -- Bug 3017533
323: , nvl(p.bill_labor_accrual, 'N') bill_labor_accrual /* Start changes for bug#12597910 */
324: FROM
325: pa_tasks t
326: , pa_projects_all p
327: , pa_project_types_all pt -- PA.L Retirement Cost Processing
328: WHERE
329: t.task_id = l_task_id -- Replaced X_task_id with l_task_id for bug 16220146

Line 807: from pa_tasks

803: G_TRX_SKIP_FLAG := nvl(Pa_Trx_Import.G_Skip_Tc_Flag,'N');
804:
805: /* Start: changes for CBS Enhancement: Bug 16220146 */
806: select count(*) into l_task_count
807: from pa_tasks
808: where project_id = X_project_id
809: and task_id = X_task_id;
810:
811: IF l_task_count <> 0 THEN