APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 15: g_api_rlmi pa_resource_list_members.resource_list_member_id%type;

11: g_current_baseline_bvid pa_budget_versions.budget_version_id%type;
12: g_api_project_id pa_budget_versions.project_id%type;
13: g_api_task_id pa_tasks.task_id%type;
14: g_api_top_task_id pa_tasks.top_task_id%type;
15: g_api_rlmi pa_resource_list_members.resource_list_member_id%type;
16: g_api_parent_rlmi pa_resource_list_members.parent_member_id%type;
17: g_txn_exists_for_bvid Varchar2(1);
18: -- R12 complete
19:

Line 16: g_api_parent_rlmi pa_resource_list_members.parent_member_id%type;

12: g_api_project_id pa_budget_versions.project_id%type;
13: g_api_task_id pa_tasks.task_id%type;
14: g_api_top_task_id pa_tasks.top_task_id%type;
15: g_api_rlmi pa_resource_list_members.resource_list_member_id%type;
16: g_api_parent_rlmi pa_resource_list_members.parent_member_id%type;
17: g_txn_exists_for_bvid Varchar2(1);
18: -- R12 complete
19:
20:

Line 1333: from pa_resource_list_members prlm where resource_list_member_id = l_rlmi;

1329:
1330: If nvl(g_api_rlmi,-1) <> l_rlmi then
1331:
1332: select nvl(parent_member_id,-99) into g_api_parent_rlmi
1333: from pa_resource_list_members prlm where resource_list_member_id = l_rlmi;
1334:
1335: g_api_rlmi := l_rlmi;
1336: End If;
1337:

Line 2767: FROM pa_resource_list_members

2763: CURSOR get_res_name
2764: (p_rs_id IN number) IS
2765: SELECT DISTINCT
2766: alias
2767: FROM pa_resource_list_members
2768: WHERE resource_list_member_id = p_rs_id;
2769: CURSOR get_task_name
2770: (p_task_id IN number) IS
2771: SELECT task_name