APPS.PA_FP_VIEW_PLANS_PUB dependencies on PA_TASKS

Line 9001: pa_tasks t

8997: cursor project_children_csr is
8998: /* Bug 3106741 rewritten for performance improvement
8999: select ra.task_id -- doesn't matter what we select here
9000: from pa_resource_assignments ra,
9001: pa_tasks t
9002: where (ra.budget_version_id in (p_budget_version_id1, p_budget_version_id2) and
9003: ra.task_id=0 and
9004: not (ra.resource_list_member_id in (0,pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id))) or
9005: (ra.budget_version_id in (p_budget_version_id1, p_budget_version_id2) and

Line 9019: from pa_tasks pt

9015: ( ra.task_id=0
9016: and not (ra.resource_list_member_id in (0,pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id)))
9017: or
9018: (exists (select 1
9019: from pa_tasks pt
9020: where pt.task_id = pt.top_task_id
9021: and pt.task_id = ra.task_id))
9022: ));
9023:

Line 9030: pa_tasks t

9026: cursor task_children_csr is
9027: /* Bug 3106741 rewritten for performance improvement
9028: select ra.task_id
9029: from pa_resource_assignments ra,
9030: pa_tasks t
9031: where (ra.budget_version_id in(p_budget_version_id1, p_budget_version_id2) and
9032: ra.task_id=p_task_id and
9033: not (ra.resource_list_member_id in (0,pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id))) or
9034: (ra.budget_version_id in (p_budget_version_id1, p_budget_version_id2) and

Line 9049: from pa_tasks t

9045: )
9046: )
9047: or
9048: (exists (select 1
9049: from pa_tasks t
9050: where ra.task_id = t.task_id
9051: and t.parent_task_id = p_task_id)
9052: )
9053: ));