DBA Data[Home] [Help]

APPS.AHL_FMP_MR_REVISION_PVT dependencies on AHL_MR_EFFECTIVITIES

Line 435: FROM AHL_MR_EFFECTIVITIES_APP_V

431: ATTRIBUTE12,
432: ATTRIBUTE13,
433: ATTRIBUTE14,
434: ATTRIBUTE15
435: FROM AHL_MR_EFFECTIVITIES_APP_V
436: WHERE MR_HEADER_ID=P_SOURCE_MR_HEADER_ID;
437:
438: CURSOR CurGetMrIntervals(C_MR_EFFECTIVITY_ID NUMBER)
439: IS

Line 1016: INSERT INTO AHL_MR_EFFECTIVITIES

1012: for l_mr_eff_rec in CurGetEffectDet
1013: loop
1014: l_old_mr_effectivity_id:=l_mr_eff_rec.mr_effectivity_id;
1015:
1016: INSERT INTO AHL_MR_EFFECTIVITIES
1017: (
1018: MR_EFFECTIVITY_ID,
1019: OBJECT_VERSION_NUMBER,
1020: LAST_UPDATE_DATE,

Line 1052: AHL_MR_EFFECTIVITIES_S.NEXTVAL,

1048: ATTRIBUTE15
1049: )
1050: VALUES
1051: (
1052: AHL_MR_EFFECTIVITIES_S.NEXTVAL,
1053: 1,
1054: SYSDATE,
1055: fnd_global.user_id,
1056: SYSDATE,