DBA Data[Home] [Help]

APPS.AHL_FMP_MR_REVISION_PVT dependencies on AHL_MR_EFFECTIVITY_EXT_DTLS

Line 556: FROM AHL_MR_EFFECTIVITY_EXT_DTLS

552: ATTRIBUTE12,
553: ATTRIBUTE13,
554: ATTRIBUTE14,
555: ATTRIBUTE15
556: FROM AHL_MR_EFFECTIVITY_EXT_DTLS
557: WHERE MR_EFFECTIVITY_ID=C_MR_EFFECTIVITY_ID;
558:
559: l_mr_effect_ext_dtls_rec CurGetEffectExtDTLS%rowtype;
560:

Line 1267: INSERT INTO AHL_MR_EFFECTIVITY_EXT_DTLS

1263:
1264: IF CurGetEffectExtDTLS%FOUND
1265: THEN
1266:
1267: INSERT INTO AHL_MR_EFFECTIVITY_EXT_DTLS
1268: (
1269: MR_EFFECTIVITY_EXT_DTL_ID,
1270: MR_EFFECTIVITY_ID,
1271: EXCLUDE_FLAG,

Line 1302: AHL_MR_EFFECTIVITY_EXT_DTLS_S.NEXTVAL,

1298: ATTRIBUTE15
1299: )
1300: VALUES
1301: (
1302: AHL_MR_EFFECTIVITY_EXT_DTLS_S.NEXTVAL,
1303: l_new_mr_EFFECTIVITY_ID,
1304: l_mr_effect_ext_dtls_rec.EXCLUDE_FLAG,
1305: l_mr_effect_ext_dtls_rec.EFFECT_EXT_DTL_REC_TYPE,
1306: l_mr_effect_ext_dtls_rec.OWNER_ID,