APPS.PA_FP_CALC_UTILS dependencies on PA_TASKS

Line 5946: ,pa_tasks t

5942: )
5943: ,tmp.billable_flag = NVL((select decode(NVL(tmp.billable_flag,'D'),'D'
5944: ,decode(NVL(ra.task_id,0),0,'Y',NVL(t.billable_flag,'N')),NVL(tmp.billable_flag,'N'))
5945: from pa_resource_assignments ra
5946: ,pa_tasks t
5947: where ra.resource_assignment_id = tmp.resource_assignment_id
5948: and t.task_id(+) = ra.task_id
5949: ),'N')
5950: ,tmp.task_name = (select t.task_name

Line 5952: ,pa_tasks t

5948: and t.task_id(+) = ra.task_id
5949: ),'N')
5950: ,tmp.task_name = (select t.task_name
5951: from pa_resource_assignments ra
5952: ,pa_tasks t
5953: where ra.resource_assignment_id = tmp.resource_assignment_id
5954: and t.task_id = ra.task_id
5955: )
5956: WHERE tmp.budget_version_id = p_budget_version_id;

Line 5984: ,pa_tasks t

5980: )
5981: ,tmp.billable_flag = NVL((select decode(NVL(tmp.billable_flag,'D'),'D'
5982: ,decode(NVL(ra.task_id,0),0,'Y',NVL(t.billable_flag,'N')),NVL(tmp.billable_flag,'N'))
5983: from pa_resource_assignments ra
5984: ,pa_tasks t
5985: where ra.resource_assignment_id = tmp.resource_assignment_id
5986: and t.task_id(+) = ra.task_id
5987: ),'N')
5988: ,tmp.task_name = (select t.task_name

Line 5990: ,pa_tasks t

5986: and t.task_id(+) = ra.task_id
5987: ),'N')
5988: ,tmp.task_name = (select t.task_name
5989: from pa_resource_assignments ra
5990: ,pa_tasks t
5991: where ra.resource_assignment_id = tmp.resource_assignment_id
5992: and t.task_id = ra.task_id
5993: )
5994: WHERE tmp.budget_version_id = p_budget_version_id;