APPS.AHL_PRD_WORKORDER_PVT dependencies on PJM_PROJECTS_ORG_OU_SECURE_V

Line 1475: -- replace MTL_PROJECT_V with PJM_PROJECTS_ORG_OU_SECURE_V for R12

1471: FND_MSG_PUB.ADD;
1472: ELSIF p_prd_workorder_rec.Project_id IS not NULL AND
1473: p_prd_workorder_rec.Project_id<>FND_API.G_MISS_NUM THEN
1474:
1475: -- replace MTL_PROJECT_V with PJM_PROJECTS_ORG_OU_SECURE_V for R12
1476: -- required for PJM MOAC changes.
1477: SELECT COUNT(*) INTO l_dummy_ctr
1478: --SELECT 1 INTO l_dummy_ctr
1479: -- FROM MTL_PROJECT_V

Line 1480: FROM PJM_PROJECTS_ORG_OU_SECURE_V

1476: -- required for PJM MOAC changes.
1477: SELECT COUNT(*) INTO l_dummy_ctr
1478: --SELECT 1 INTO l_dummy_ctr
1479: -- FROM MTL_PROJECT_V
1480: FROM PJM_PROJECTS_ORG_OU_SECURE_V
1481: WHERE project_id=p_prd_workorder_rec.PROJECT_ID
1482: AND org_id = mo_global.get_current_org_id()
1483: -- added following filter to fix bug# 8662561 (FP for 8630840)
1484: AND inventory_organization_id = p_prd_workorder_rec.organization_id;

Line 3299: -- replace MTL_PROJECT_V with PJM_PROJECTS_ORG_OU_SECURE_V for R12

3295:
3296: -- AVIKUKUM ::Bug #9002741 :: 30-NOV-2010
3297: -- Commented out the cursor get_project_num as project number is not needed now
3298: /*-- rroy
3299: -- replace MTL_PROJECT_V with PJM_PROJECTS_ORG_OU_SECURE_V for R12
3300: -- required for PJM MOAC changes.
3301: CURSOR get_project_num(c_project_id NUMBER)
3302: IS
3303: SELECT project_number

Line 3305: FROM PJM_PROJECTS_ORG_OU_SECURE_V

3301: CURSOR get_project_num(c_project_id NUMBER)
3302: IS
3303: SELECT project_number
3304: --FROM MTL_PROJECT_V
3305: FROM PJM_PROJECTS_ORG_OU_SECURE_V
3306: WHERE project_id = c_project_id;*/
3307:
3308: CURSOR get_visit_name(c_visit_id NUMBER)
3309: IS