APPS.AHL_COMPLETIONS_PVT dependencies on DUAL

Line 875: FROM DUAL;

871: BEGIN
872:
873: SELECT AHL_WORKORDER_TXNS_S.NEXTVAL
874: INTO l_workorder_txn_id
875: FROM DUAL;
876:
877: INSERT INTO AHL_WORKORDER_TXNS
878: (
879: WORKORDER_TXN_ID,

Line 1315: FROM DUAL;

1311: BEGIN
1312:
1313: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL
1314: INTO l_wo_operation_txn_id
1315: FROM DUAL;
1316:
1317: INSERT INTO AHL_WO_OPERATIONS_TXNS
1318: (
1319: WO_OPERATION_TXN_ID,

Line 4537: from dual)

4533: connect by prior related_ue_id = ue_id
4534: AND relationship_code = 'PARENT'
4535: union all
4536: select c_unit_effectivity_id
4537: from dual)
4538: AND rownum < 2;
4539:
4540: CURSOR is_mr_on_hold_csr(c_unit_effectivity_id NUMBER) IS
4541: SELECT

Line 4556: from dual)

4552: connect by prior related_ue_id = ue_id
4553: AND relationship_code = 'PARENT'
4554: union all
4555: select c_unit_effectivity_id
4556: from dual)
4557: AND rownum < 2;
4558:
4559: CURSOR is_mr_complete_csr(c_unit_effectivity_id NUMBER) IS
4560: SELECT

Line 4576: from dual)

4572: connect by prior related_ue_id = ue_id
4573: AND relationship_code = 'PARENT'
4574: union all
4575: select c_unit_effectivity_id
4576: from dual)
4577: AND rownum < 2;
4578:
4579: CURSOR is_mr_cancelled_csr(c_unit_effectivity_id NUMBER) IS
4580: SELECT

Line 4597: from dual)

4593: connect by prior related_ue_id = ue_id
4594: AND relationship_code = 'PARENT'
4595: union all
4596: select c_unit_effectivity_id
4597: from dual)
4598: AND rownum < 2;
4599:
4600: BEGIN
4601: