DBA Data[Home] [Help]

APPS.AHL_FMP_MR_REVISION_PVT dependencies on AHL_MR_EFFECTIVITIES

Line 426: FROM AHL_MR_EFFECTIVITIES_APP_V

422: ATTRIBUTE12,
423: ATTRIBUTE13,
424: ATTRIBUTE14,
425: ATTRIBUTE15
426: FROM AHL_MR_EFFECTIVITIES_APP_V
427: WHERE MR_HEADER_ID=P_SOURCE_MR_HEADER_ID;
428:
429: CURSOR CurGetMrIntervals(C_MR_EFFECTIVITY_ID NUMBER)
430: IS

Line 862: INSERT INTO AHL_MR_EFFECTIVITIES

858: for l_mr_eff_rec in CurGetEffectDet
859: loop
860: l_old_mr_effectivity_id:=l_mr_eff_rec.mr_effectivity_id;
861:
862: INSERT INTO AHL_MR_EFFECTIVITIES
863: (
864: MR_EFFECTIVITY_ID,
865: OBJECT_VERSION_NUMBER,
866: LAST_UPDATE_DATE,

Line 897: AHL_MR_EFFECTIVITIES_S.NEXTVAL,

893: ATTRIBUTE15
894: )
895: VALUES
896: (
897: AHL_MR_EFFECTIVITIES_S.NEXTVAL,
898: 1,
899: SYSDATE,
900: fnd_global.user_id,
901: SYSDATE,