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 1461: from pa_resource_lists prl,

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

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

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

Line 2683: pa_resource_lists prl,

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

Line 5565: FROM pa_resource_lists prl

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

Line 6319: FROM pa_resource_lists prl

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

Line 7003: FROM pa_resource_lists prl

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