APPS.AHL_RM_ROUTE_PVT dependencies on AHL_ALTERNATE_RESOURCES

Line 3518: INSERT INTO AHL_ALTERNATE_RESOURCES

3514: l_get_rt_oper_resources.SCHEDULE_SEQ
3515: -- Bug # 7644260 (FP for ER # 6998882) -- end
3516: );
3517:
3518: INSERT INTO AHL_ALTERNATE_RESOURCES
3519: (
3520: ALTERNATE_RESOURCE_ID,
3521: OBJECT_VERSION_NUMBER,
3522: LAST_UPDATE_DATE,

Line 3548: AHL_ALTERNATE_RESOURCES_S.NEXTVAL,

3544: ATTRIBUTE14,
3545: ATTRIBUTE15
3546: )
3547: SELECT
3548: AHL_ALTERNATE_RESOURCES_S.NEXTVAL,
3549: 1,
3550: SYSDATE,
3551: FND_GLOBAL.user_id,
3552: SYSDATE,

Line 3574: FROM AHL_ALTERNATE_RESOURCES

3570: ATTRIBUTE12,
3571: ATTRIBUTE13,
3572: ATTRIBUTE14,
3573: ATTRIBUTE15
3574: FROM AHL_ALTERNATE_RESOURCES
3575: WHERE rt_oper_resource_id = l_get_rt_oper_resources.rt_oper_resource_id;
3576: END LOOP;
3577:
3578: -- 3.Copy Reference Documents