APPS.AHL_RM_APPROVAL_PVT dependencies on AHL_OPERATIONS_B_KFV

Line 68: FROM AHL_OPERATIONS_B_KFV

64:
65: CURSOR CurOperDet
66: is
67: SELECT *
68: FROM AHL_OPERATIONS_B_KFV
69: WHERE OPERATION_ID=p_activity_id;
70:
71: l_oper_Rec CurOperDet%rowtype;
72:

Line 283: From ahl_operations_b_KFV

279: revision_number,
280: start_date_active,
281: end_date_active,
282: concatenated_segments
283: From ahl_operations_b_KFV
284: Where operation_id = c_operation_id;
285:
286: l_oper_rec get_oper_Det%rowtype;
287:

Line 295: From ahl_operations_b_kfv

291: revision_number,
292: start_date_active,
293: end_date_active,
294: concatenated_segments
295: From ahl_operations_b_kfv
296: Where operation_id = c_operation_id;
297:
298: -- Bug # 8639648 -- start
299: -- Fetches all active routes which has time span greater than

Line 490: FROM AHL_OPERATIONS_B_KFV

486: THEN
487: l_upd_status := 'TERMINATION_PENDING';
488:
489: SELECT COUNT(*) into l_counter
490: FROM AHL_OPERATIONS_B_KFV
491: WHERE CONCATENATED_SEGMENTS=l_oper_Rec.CONCATENATED_SEGMENTS
492: AND REVISION_NUMBER=l_oper_Rec.revision_number+1;
493:
494: IF l_counter>0

Line 1455: FROM AHL_OPERATIONS_B_KFV

1451: CONCATENATED_SEGMENTS,
1452: REVISION_NUMBER,
1453: START_DATE_ACTIVE,
1454: END_DATE_ACTIVE
1455: FROM AHL_OPERATIONS_B_KFV
1456: WHERE OPERATION_ID=C_OPERATION_ID;
1457:
1458: CURSOR GetPrevOperDet(C_REVISION_NUMBER NUMBER,C_CONCATENATED_SEGMENTS VARCHAR2)
1459: IS

Line 1465: FROM AHL_OPERATIONS_B_KFV

1461: CONCATENATED_SEGMENTS,
1462: REVISION_NUMBER,
1463: START_DATE_ACTIVE,
1464: END_DATE_ACTIVE
1465: FROM AHL_OPERATIONS_B_KFV
1466: WHERE CONCATENATED_SEGMENTS=C_CONCATENATED_SEGMENTS
1467: AND REVISION_NUMBER=C_REVISION_NUMBER-1;
1468:
1469: l_oper_rec GetOperationDet%rowtype;

Line 1500: FROM AHL_OPERATIONS_B_KFV WHERE OPERATION_ID=p_operation_id;

1496: AHL_DEBUG_PUB.debug( 'Complete_mr_revision Status----->'||p_appr_status,'+DEBUG_RELATIONS+');
1497: END IF;
1498:
1499: SELECT REVISION_STATUS_CODE INTO l_curr_status
1500: FROM AHL_OPERATIONS_B_KFV WHERE OPERATION_ID=p_operation_id;
1501:
1502: IF p_appr_status='APPROVED'
1503: THEN
1504: l_status:='COMPLETE';