APPS.OE_HOLDS_PVT dependencies on PJM_PROJECTS_ORG_OU_SECURE_V

Line 219: from PJM_PROJECTS_ORG_OU_SECURE_V

215: AND lookup_type = 'SALES_CHANNEL';
216:
217: CURSOR project_value_cur IS
218: select PROJECT_NAME
219: from PJM_PROJECTS_ORG_OU_SECURE_V
220: WHERE PROJECT_ID = p_hold_entity_id;
221:
222: CURSOR task_value_cur IS
223: select TASK_NAME

Line 2470: FROM PJM_PROJECTS_ORG_OU_SECURE_V

2466: where inventory_item_id = p_hold_source_rec.hold_entity_id;
2467: ELSIF p_hold_source_rec.hold_entity_code = 'PR' THEN
2468: SELECT 'Valid Entity'
2469: INTO l_dummy
2470: FROM PJM_PROJECTS_ORG_OU_SECURE_V
2471: WHERE PROJECT_ID = p_hold_source_rec.hold_entity_id;
2472: ELSIF p_hold_source_rec.hold_entity_code = 'PL' THEN
2473: SELECT 'Valid Entity'
2474: INTO l_dummy

Line 2637: FROM PJM_PROJECTS_ORG_OU_SECURE_V

2633: where list_header_id = p_hold_source_rec.hold_entity_id2;
2634: ELSIF p_hold_source_rec.hold_entity_code2 = 'PR' THEN
2635: SELECT 'Valid Entity'
2636: INTO l_dummy
2637: FROM PJM_PROJECTS_ORG_OU_SECURE_V
2638: WHERE PROJECT_ID = p_hold_source_rec.hold_entity_id2;
2639: ELSIF p_hold_source_rec.hold_entity_code2 = 'SC' THEN
2640: SELECT 'Valid Entity'
2641: INTO l_dummy