APPS.PA_FP_CALC_UTILS dependencies on PA_TASKS

Line 5917: ,pa_tasks t

5913: )
5914: ,tmp.billable_flag = NVL((select decode(NVL(tmp.billable_flag,'D'),'D'
5915: ,decode(NVL(ra.task_id,0),0,'Y',NVL(t.billable_flag,'N')),NVL(tmp.billable_flag,'N'))
5916: from pa_resource_assignments ra
5917: ,pa_tasks t
5918: where ra.resource_assignment_id = tmp.resource_assignment_id
5919: and t.task_id(+) = ra.task_id
5920: ),'N')
5921: ,tmp.task_name = (select t.task_name

Line 5923: ,pa_tasks t

5919: and t.task_id(+) = ra.task_id
5920: ),'N')
5921: ,tmp.task_name = (select t.task_name
5922: from pa_resource_assignments ra
5923: ,pa_tasks t
5924: where ra.resource_assignment_id = tmp.resource_assignment_id
5925: and t.task_id = ra.task_id
5926: )
5927: WHERE tmp.budget_version_id = p_budget_version_id;

Line 5955: ,pa_tasks t

5951: )
5952: ,tmp.billable_flag = NVL((select decode(NVL(tmp.billable_flag,'D'),'D'
5953: ,decode(NVL(ra.task_id,0),0,'Y',NVL(t.billable_flag,'N')),NVL(tmp.billable_flag,'N'))
5954: from pa_resource_assignments ra
5955: ,pa_tasks t
5956: where ra.resource_assignment_id = tmp.resource_assignment_id
5957: and t.task_id(+) = ra.task_id
5958: ),'N')
5959: ,tmp.task_name = (select t.task_name

Line 5961: ,pa_tasks t

5957: and t.task_id(+) = ra.task_id
5958: ),'N')
5959: ,tmp.task_name = (select t.task_name
5960: from pa_resource_assignments ra
5961: ,pa_tasks t
5962: where ra.resource_assignment_id = tmp.resource_assignment_id
5963: and t.task_id = ra.task_id
5964: )
5965: WHERE tmp.budget_version_id = p_budget_version_id;