DBA Data[Home] [Help]

APPS.GMS_BUDGET_PUB dependencies on PA_IMPLEMENTATIONS

Line 1463: pa_implementations pi

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

Line 5568: , pa_implementations pi

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

Line 6322: , pa_implementations pi

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

Line 7006: , pa_implementations pi

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