DBA Data[Home] [Help]

APPS.GMS_BUDGET_PUB dependencies on PA_IMPLEMENTATIONS

Line 1462: pa_implementations pi

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:
1466: cursor baselined_budg_csr (p_project_id IN NUMBER,

Line 5567: , pa_implementations pi

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
5570: AND prl.uncategorized_flag='Y'
5571: and NVL(prl.migration_code,'M') ='M' -- Bug 3626671

Line 6321: , pa_implementations pi

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
6324: AND prl.uncategorized_flag='Y'
6325: and NVL(prl.migration_code,'M') ='M' -- Bug 3626671

Line 7005: , pa_implementations pi

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
7008: AND prl.uncategorized_flag='Y'
7009: and NVL(prl.migration_code,'M') ='M' -- Bug 3626671