APPS.AHL_UMP_UNPLANNED_PVT dependencies on DUAL

Line 85: FROM DUAL

81:
82: -- check for group MR.
83: CURSOR is_grp_mr_check(p_mr_header_id IN NUMBER) IS
84: SELECT 'x'
85: FROM DUAL
86: WHERE EXISTS (SELECT r.related_mr_header_id
87: FROM ahl_mr_relationships r
88: WHERE r.mr_header_id = p_mr_header_id
89: AND EXISTS (SELECT m.mr_header_id

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,

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

537: FETCH get_rel_mr_ue_id into l_unit_effectivity_id;
538: CLOSE get_rel_mr_ue_id;
539: END IF;
540:
541: SELECT AHL_UE_RELATIONSHIPS_S.NEXTVAL INTO l_ue_relationship_id FROM DUAL;
542:
543: AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW
544: (
545: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,