APPS.AHL_COMPLETIONS_PVT dependencies on DUAL

Line 901: FROM DUAL;

897: BEGIN
898:
899: SELECT AHL_WORKORDER_TXNS_S.NEXTVAL
900: INTO l_workorder_txn_id
901: FROM DUAL;
902:
903: INSERT INTO AHL_WORKORDER_TXNS
904: (
905: WORKORDER_TXN_ID,

Line 1362: FROM DUAL;

1358: BEGIN
1359:
1360: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL
1361: INTO l_wo_operation_txn_id
1362: FROM DUAL;
1363:
1364: INSERT INTO AHL_WO_OPERATIONS_TXNS
1365: (
1366: WO_OPERATION_TXN_ID,

Line 4653: from dual)

4649: connect by prior related_ue_id = ue_id
4650: AND relationship_code = 'PARENT'
4651: union all
4652: select c_unit_effectivity_id
4653: from dual)
4654: AND rownum < 2;
4655:
4656: CURSOR is_mr_on_hold_csr(c_unit_effectivity_id NUMBER) IS
4657: SELECT

Line 4672: from dual)

4668: connect by prior related_ue_id = ue_id
4669: AND relationship_code = 'PARENT'
4670: union all
4671: select c_unit_effectivity_id
4672: from dual)
4673: AND rownum < 2;
4674:
4675: CURSOR is_mr_complete_csr(c_unit_effectivity_id NUMBER) IS
4676: SELECT

Line 4692: from dual)

4688: connect by prior related_ue_id = ue_id
4689: AND relationship_code = 'PARENT'
4690: union all
4691: select c_unit_effectivity_id
4692: from dual)
4693: AND rownum < 2;
4694:
4695: CURSOR is_mr_cancelled_csr(c_unit_effectivity_id NUMBER) IS
4696: SELECT

Line 4713: from dual)

4709: connect by prior related_ue_id = ue_id
4710: AND relationship_code = 'PARENT'
4711: union all
4712: select c_unit_effectivity_id
4713: from dual)
4714: AND rownum < 2;
4715:
4716: BEGIN
4717: