APPS.GMS_BUDGET_PUB dependencies on PA_RESOURCE_LISTS

Line 352: from pa_resource_lists

348:
349: cursor l_resource_list_id_csr(p_resource_list_id_in NUMBER)
350: IS
351: select 'X'
352: from pa_resource_lists
353: where resource_list_id = p_resource_list_id_in;
354:
355: cursor l_resource_list_name_csr(p_resource_list_name_in VARCHAR2)
356: is

Line 358: from pa_resource_lists

354:
355: cursor l_resource_list_name_csr(p_resource_list_name_in VARCHAR2)
356: is
357: select resource_list_id
358: from pa_resource_lists
359: where name = p_resource_list_name_in
360: and NVL(migration_code,'M') ='M'; -- Bug 3626671
361:
362: l_dummy VARCHAR2(1);

Line 1462: from pa_resource_lists prl,

1458:
1459: cursor resource_list_detail_csr(p_resource_list_id IN NUMBER)
1460: IS
1461: select uncategorized_flag
1462: from pa_resource_lists prl,
1463: pa_implementations pi
1464: where prl.business_group_id = pi.business_group_id
1465: and prl.resource_list_id = p_resource_list_id;
1466:

Line 1978: -- pa_resource_lists table. If both are missing then raise an error.

1974:
1975: ------------------------------------------------------------------------------
1976: -- If resource_list_id is passed in then use it otherwise use the resource_list
1977: -- name (NAME) that is passed in to fetch value of resource_list_id from
1978: -- pa_resource_lists table. If both are missing then raise an error.
1979:
1980: IF (p_resource_list_name <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
1981: AND p_resource_list_name IS NOT NULL)
1982: OR (p_resource_list_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM

Line 2684: pa_resource_lists prl,

2680: t.project_type_class_code,
2681: prl.group_resource_type_id
2682: FROM pa_project_types t,
2683: pa_projects p,
2684: pa_resource_lists prl,
2685: gms_budget_versions v
2686: WHERE v.budget_version_id = p_draft_version_id
2687: AND v.project_id = p.project_id
2688: AND prl.resource_list_id = v.resource_list_id

Line 5566: FROM pa_resource_lists prl

5562:
5563: CURSOR l_uncategorized_list_csr
5564: IS
5565: SELECT prlm.resource_list_member_id
5566: FROM pa_resource_lists prl
5567: , pa_resource_list_members prlm
5568: , pa_implementations pi
5569: WHERE prl.resource_list_id = prlm.resource_list_id
5570: AND prl.business_group_id = pi.business_group_id

Line 6320: FROM pa_resource_lists prl

6316:
6317: CURSOR l_uncategorized_list_csr
6318: IS
6319: SELECT prlm.resource_list_member_id
6320: FROM pa_resource_lists prl
6321: , pa_resource_list_members prlm
6322: , pa_implementations pi
6323: WHERE prl.resource_list_id = prlm.resource_list_id
6324: AND prl.business_group_id = pi.business_group_id

Line 7004: FROM pa_resource_lists prl

7000:
7001: CURSOR l_uncat_list_member_csr
7002: IS
7003: SELECT prlm.resource_list_member_id
7004: FROM pa_resource_lists prl
7005: , pa_resource_list_members prlm
7006: , pa_implementations pi
7007: WHERE prl.resource_list_id = prlm.resource_list_id
7008: AND prl.business_group_id = pi.business_group_id