APPS.AHL_FMP_MR_REVISION_PVT dependencies on AHL_MR_VISIT_TYPES

Line 634: FROM AHL_MR_VISIT_TYPES

630: ATTRIBUTE12,
631: ATTRIBUTE13,
632: ATTRIBUTE14,
633: ATTRIBUTE15
634: FROM AHL_MR_VISIT_TYPES
635: WHERE MR_HEADER_ID=P_SOURCE_MR_HEADER_ID;
636:
637: l_mrvsttype_rec CurGetMrVisitTypes%rowtype;
638: --Changes for SBE begin: MR Loop/Chain relationships

Line 1414: INSERT INTO AHL_MR_VISIT_TYPES

1410: -- start visit types
1411:
1412: FOR l_mrvisttype_rec in CurGetMrVisitTypes
1413: LOOP
1414: INSERT INTO AHL_MR_VISIT_TYPES
1415: (
1416: MR_VISIT_TYPE_ID,
1417: OBJECT_VERSION_NUMBER,
1418: LAST_UPDATE_DATE,

Line 1445: AHL_MR_VISIT_TYPES_S.NEXTVAL,

1441: MR_VISIT_TYPE_CODE
1442: )
1443: VALUES
1444: (
1445: AHL_MR_VISIT_TYPES_S.NEXTVAL,
1446: 1,
1447: SYSDATE,
1448: fnd_global.user_id,
1449: SYSDATE,