APPS.AHL_VWP_RULES_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 1214: SELECT unit_effectivity_id FROM Ahl_Unit_effectivities_b

1210:
1211: -- SKPATHAK :: Bug 13574991 :: 16-FEB-2012 :: FPed all fixes on R121 codeline
1212: -- TCHIMIRA :: Bug 10088921 :: 15-NOV-2010
1213: CURSOR c_row_lock(x_id IN NUMBER) IS
1214: SELECT unit_effectivity_id FROM Ahl_Unit_effectivities_b
1215: WHERE unit_effectivity_id = x_id
1216: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1217:
1218: -- SKPATHAK :: 13914410 :: 03-APR-2012

Line 3621: FROM ahl_unit_effectivities_b

3617: AND TRUNC(NVL(end_date_active,SYSDATE));
3618:
3619: CURSOR get_object_type (c_unit_effectivity_id NUMBER) IS
3620: SELECT object_type
3621: FROM ahl_unit_effectivities_b
3622: WHERE unit_effectivity_id = c_unit_effectivity_id;
3623:
3624: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Service_Type';
3625: l_debug_key CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;

Line 5710: AHL_UNIT_EFFECTIVITIES_B AUEF

5706: SELECT TSK.OBJECT_VERSION_NUMBER,
5707: TSK.SERVICE_REQUEST_ID,
5708: AUEF.MANUALLY_PLANNED_FLAG
5709: FROM AHL_VISIT_TASKS_B TSK,
5710: AHL_UNIT_EFFECTIVITIES_B AUEF
5711: WHERE TSK.VISIT_TASK_ID = c_task_id
5712: AND TSK.UNIT_EFFECTIVITY_ID = AUEF.UNIT_EFFECTIVITY_ID;
5713:
5714: update_task_rec update_visit_task_csr%ROWTYPE;