APPS.AHL_UMP_UNPLANNED_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B_S

Line 381: SELECT AHL_UNIT_EFFECTIVITIES_B_S.NEXTVAL INTO l_unit_effectivity_id FROM DUAL;

377: END IF;
378:
379: -- BACHANDR - NR project end
380:
381: SELECT AHL_UNIT_EFFECTIVITIES_B_S.NEXTVAL INTO l_unit_effectivity_id FROM DUAL;
382:
383: AHL_UNIT_EFFECTIVITIES_PKG.INSERT_ROW (
384: X_ROWID => l_rowid,
385: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_id,

Line 511: SELECT AHL_UNIT_EFFECTIVITIES_B_S.NEXTVAL INTO l_unit_effectivity_id FROM DUAL;

507: l_uc_header_id := AHL_UTIL_UC_PKG.get_uc_header_id(p_instance_id => l_appl_mrs_relns.RELATED_CSI_ITEM_INSTANCE_ID);
508: -- BACHANDR - NR project end
509: */
510:
511: SELECT AHL_UNIT_EFFECTIVITIES_B_S.NEXTVAL INTO l_unit_effectivity_id FROM DUAL;
512:
513: AHL_UNIT_EFFECTIVITIES_PKG.INSERT_ROW (
514: X_ROWID => l_rowid,
515: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_id,