APPS.PA_FP_VIEW_PLANS_PUB dependencies on PA_RESOURCE_LIST_MEMBERS

Line 10603: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;

10599: p_amt_or_periodic IN VARCHAR2) return VARCHAR2
10600: IS
10601:
10602: l_return_value VARCHAR2(1);
10603: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
10604: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
10605:
10606: cursor project_children_csr is
10607: /* Bug 3106741 rewritten for performance improvement

Line 10604: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;

10600: IS
10601:
10602: l_return_value VARCHAR2(1);
10603: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
10604: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
10605:
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

Line 10668: from pa_resource_list_members

10664: task_children_rec task_children_csr%ROWTYPE;
10665:
10666: cursor rg_children_csr is
10667: select resource_list_member_id
10668: from pa_resource_list_members
10669: where parent_member_id = p_resource_list_member_id;
10670: rg_children_rec rg_children_csr%ROWTYPE;
10671:
10672: BEGIN

Line 10726: from pa_resource_list_members

10722: select nvl(parent_member_id, -99),
10723: resource_list_id
10724: into l_res_parent_member_id,
10725: l_resource_list_id
10726: from pa_resource_list_members
10727: where resource_list_member_id = p_resource_list_member_id;
10728: if l_res_parent_member_id = -99 then
10729: /* THIS IS A RESOURCE LIST */
10730: open rg_children_csr;