APPS.AHL_UMP_UNPLANNED_PVT dependencies on DUAL

Line 96: FROM DUAL

92:
93: -- check for group MR.
94: CURSOR is_grp_mr_check(p_mr_header_id IN NUMBER) IS
95: SELECT 'x'
96: FROM DUAL
97: WHERE EXISTS (SELECT r.related_mr_header_id
98: FROM ahl_mr_relationships r
99: WHERE r.mr_header_id = p_mr_header_id
100: AND EXISTS (SELECT m.mr_header_id

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,

Line 615: SELECT AHL_UE_RELATIONSHIPS_S.NEXTVAL INTO l_ue_relationship_id FROM DUAL;

611: FETCH get_rel_mr_ue_id into l_unit_effectivity_id;
612: CLOSE get_rel_mr_ue_id;
613: END IF;
614:
615: SELECT AHL_UE_RELATIONSHIPS_S.NEXTVAL INTO l_ue_relationship_id FROM DUAL;
616:
617: AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW
618: (
619: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,