APPS.PA_FP_VIEW_PLANS_PUB dependencies on PA_TASKS

Line 3765: select t.task_id from pa_tasks t

3761: l_currency_type VARCHAR2(30);
3762:
3763: /* Added for bug 13907149*/
3764: cursor parent_tasks_csr(p_task_id in NUMBER) is
3765: select t.task_id from pa_tasks t
3766: START WITH t.task_id = p_task_id
3767: CONNECT BY prior t.parent_task_id = t.task_id;
3768:
3769: cursor rollup_period_amt_csr is

Line 6867: select t.task_id from pa_tasks t

6863: l_currency_type VARCHAR2(30);
6864:
6865: /* Added for bug 7514054 */
6866: cursor parent_tasks_csr(p_task_id in NUMBER) is
6867: select t.task_id from pa_tasks t
6868: START WITH t.task_id = p_task_id
6869: CONNECT BY prior t.parent_task_id = t.task_id;
6870:
6871: cursor rollup_period_amt_csr is

Line 8304: select t.task_id from pa_tasks t

8300: /* Added for bug 7514054 */
8301: l_cnt number;
8302:
8303: cursor parent_tasks_csr(p_task_id in NUMBER) is
8304: select t.task_id from pa_tasks t
8305: START WITH t.task_id = p_task_id
8306: CONNECT BY prior t.parent_task_id = t.task_id;
8307:
8308:

Line 10610: pa_tasks t

10606: cursor project_children_csr is
10607: /* Bug 3106741 rewritten for performance improvement
10608: select ra.task_id -- doesn't matter what we select here
10609: from pa_resource_assignments ra,
10610: pa_tasks t
10611: where (ra.budget_version_id in (p_budget_version_id1, p_budget_version_id2) and
10612: ra.task_id=0 and
10613: not (ra.resource_list_member_id in (0,pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id))) or
10614: (ra.budget_version_id in (p_budget_version_id1, p_budget_version_id2) and

Line 10628: from pa_tasks pt

10624: ( ra.task_id=0
10625: and not (ra.resource_list_member_id in (0,pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id)))
10626: or
10627: (exists (select 1
10628: from pa_tasks pt
10629: where pt.task_id = pt.top_task_id
10630: and pt.task_id = ra.task_id))
10631: ));
10632:

Line 10639: pa_tasks t

10635: cursor task_children_csr is
10636: /* Bug 3106741 rewritten for performance improvement
10637: select ra.task_id
10638: from pa_resource_assignments ra,
10639: pa_tasks t
10640: where (ra.budget_version_id in(p_budget_version_id1, p_budget_version_id2) and
10641: ra.task_id=p_task_id and
10642: not (ra.resource_list_member_id in (0,pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id))) or
10643: (ra.budget_version_id in (p_budget_version_id1, p_budget_version_id2) and

Line 10658: from pa_tasks t

10654: )
10655: )
10656: or
10657: (exists (select 1
10658: from pa_tasks t
10659: where ra.task_id = t.task_id
10660: and t.parent_task_id = p_task_id)
10661: )
10662: ));