APPS.AHL_UMP_UNPLANNED_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B_S

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

333: l_all_appl_mrs.descendent_count := l_applicable_mr_tbl(k).descendent_count;
334:
335: END IF; -- is_grp_mr_check%FOUND
336:
337: SELECT AHL_UNIT_EFFECTIVITIES_B_S.NEXTVAL INTO l_unit_effectivity_id FROM DUAL;
338:
339: AHL_UNIT_EFFECTIVITIES_PKG.INSERT_ROW (
340: X_ROWID => l_rowid,
341: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_id,

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

437:
438: FOR l_appl_mrs_relns IN Get_Appl_Mr_Relns
439: LOOP
440:
441: SELECT AHL_UNIT_EFFECTIVITIES_B_S.NEXTVAL INTO l_unit_effectivity_id FROM DUAL;
442:
443: AHL_UNIT_EFFECTIVITIES_PKG.INSERT_ROW (
444: X_ROWID => l_rowid,
445: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_id,