APPS.PA_FP_VIEW_PLANS_PUB dependencies on PA_RESOURCE_LIST_MEMBERS

Line 8994: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;

8990: p_amt_or_periodic IN VARCHAR2) return VARCHAR2
8991: IS
8992:
8993: l_return_value VARCHAR2(1);
8994: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
8995: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
8996:
8997: cursor project_children_csr is
8998: /* Bug 3106741 rewritten for performance improvement

Line 8995: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;

8991: IS
8992:
8993: l_return_value VARCHAR2(1);
8994: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
8995: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
8996:
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

Line 9059: from pa_resource_list_members

9055: task_children_rec task_children_csr%ROWTYPE;
9056:
9057: cursor rg_children_csr is
9058: select resource_list_member_id
9059: from pa_resource_list_members
9060: where parent_member_id = p_resource_list_member_id;
9061: rg_children_rec rg_children_csr%ROWTYPE;
9062:
9063: BEGIN

Line 9117: from pa_resource_list_members

9113: select nvl(parent_member_id, -99),
9114: resource_list_id
9115: into l_res_parent_member_id,
9116: l_resource_list_id
9117: from pa_resource_list_members
9118: where resource_list_member_id = p_resource_list_member_id;
9119: if l_res_parent_member_id = -99 then
9120: /* THIS IS A RESOURCE LIST */
9121: open rg_children_csr;