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: l_oper_rec1 get_oper_Det2%rowtype;
299: l_msg VARCHAR2(30);

Line 434: FROM AHL_OPERATIONS_B_KFV

430: THEN
431: l_upd_status := 'TERMINATION_PENDING';
432:
433: SELECT COUNT(*) into l_counter
434: FROM AHL_OPERATIONS_B_KFV
435: WHERE CONCATENATED_SEGMENTS=l_oper_Rec.CONCATENATED_SEGMENTS
436: AND REVISION_NUMBER=l_oper_Rec.revision_number+1;
437:
438: IF l_counter>0

Line 1395: FROM AHL_OPERATIONS_B_KFV

1391: CONCATENATED_SEGMENTS,
1392: REVISION_NUMBER,
1393: START_DATE_ACTIVE,
1394: END_DATE_ACTIVE
1395: FROM AHL_OPERATIONS_B_KFV
1396: WHERE OPERATION_ID=C_OPERATION_ID;
1397:
1398: CURSOR GetPrevOperDet(C_REVISION_NUMBER NUMBER,C_CONCATENATED_SEGMENTS VARCHAR2)
1399: IS

Line 1405: FROM AHL_OPERATIONS_B_KFV

1401: CONCATENATED_SEGMENTS,
1402: REVISION_NUMBER,
1403: START_DATE_ACTIVE,
1404: END_DATE_ACTIVE
1405: FROM AHL_OPERATIONS_B_KFV
1406: WHERE CONCATENATED_SEGMENTS=C_CONCATENATED_SEGMENTS
1407: AND REVISION_NUMBER=C_REVISION_NUMBER-1;
1408:
1409: l_oper_rec GetOperationDet%rowtype;

Line 1440: FROM AHL_OPERATIONS_B_KFV WHERE OPERATION_ID=p_operation_id;

1436: AHL_DEBUG_PUB.debug( 'Complete_mr_revision Status----->'||p_appr_status,'+DEBUG_RELATIONS+');
1437: END IF;
1438:
1439: SELECT REVISION_STATUS_CODE INTO l_curr_status
1440: FROM AHL_OPERATIONS_B_KFV WHERE OPERATION_ID=p_operation_id;
1441:
1442: IF p_appr_status='APPROVED'
1443: THEN
1444: l_status:='COMPLETE';