DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_UTILS2 dependencies on PA_TASKS

Line 2189: FROM pa_tasks t

2185: ,p_task_id NUMBER) RETURN varchar2 IS
2186:
2187: CURSOR cur_TaskBillable IS
2188: SELECT NVL(t.billable_flag,'N')
2189: FROM pa_tasks t
2190: WHERE t.task_id = p_task_id
2191: AND t.project_id = p_project_id;
2192:
2193: X_billable_flag Varchar2(10);

Line 3063: FROM pa_tasks t

3059: ,t.non_labor_sch_type
3060: ,t.top_task_id
3061: ,NVL(t.billable_flag,'Y')
3062: ,t.task_name
3063: FROM pa_tasks t
3064: WHERE t.task_id = tmp.task_id
3065: AND t.project_id = p_project_id
3066: )
3067: WHERE tmp.budget_version_id = p_budget_version_id

Line 3070: from pa_tasks t1

3066: )
3067: WHERE tmp.budget_version_id = p_budget_version_id
3068: AND (tmp.task_id is NOT NULL OR tmp.task_id <> 0 )
3069: AND EXISTS (select null
3070: from pa_tasks t1
3071: Where t1.task_id = tmp.task_id
3072: and t1.project_id = p_project_id
3073: );
3074: END If;