DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_UTILS2 dependencies on PA_TASKS

Line 2196: FROM pa_tasks t

2192: ,p_task_id NUMBER) RETURN varchar2 IS
2193:
2194: CURSOR cur_TaskBillable IS
2195: SELECT NVL(t.billable_flag,'N')
2196: FROM pa_tasks t
2197: WHERE t.task_id = p_task_id
2198: AND t.project_id = p_project_id;
2199:
2200: X_billable_flag Varchar2(10);

Line 3070: FROM pa_tasks t

3066: ,t.non_labor_sch_type
3067: ,t.top_task_id
3068: ,NVL(t.billable_flag,'Y')
3069: ,t.task_name
3070: FROM pa_tasks t
3071: WHERE t.task_id = tmp.task_id
3072: AND t.project_id = p_project_id
3073: )
3074: WHERE tmp.budget_version_id = p_budget_version_id

Line 3077: from pa_tasks t1

3073: )
3074: WHERE tmp.budget_version_id = p_budget_version_id
3075: AND (tmp.task_id is NOT NULL OR tmp.task_id <> 0 )
3076: AND EXISTS (select null
3077: from pa_tasks t1
3078: Where t1.task_id = tmp.task_id
3079: and t1.project_id = p_project_id
3080: );
3081: END If;