APPS.AMS_ACTMETRICS_SEED_PVT dependencies on DUAL

Line 746: SELECT 1 FROM DUAL WHERE H.FLOW_STATUS_CODE = G_BOOKED

742: AND H.BOOKED_FLAG = G_BOOKED_FLAG
743: AND H.BOOKED_DATE IS NOT NULL
744: AND H.MARKETING_SOURCE_CODE_ID = C.SOURCE_CODE_ID
745: AND EXISTS (
746: SELECT 1 FROM DUAL WHERE H.FLOW_STATUS_CODE = G_BOOKED
747: UNION ALL
748: SELECT /*+ FIRST_ROWS */ 1
749: FROM OE_SYSTEM_PARAMETERS_ALL OSPA, MTL_SYSTEM_ITEMS_B ITEM
750: WHERE H.ORG_ID = OSPA.ORG_ID

Line 1296: SELECT 1 FROM dual WHERE H.flow_status_code = G_BOOKED

1292: AND H.booked_flag = G_BOOKED_FLAG
1293: AND H.booked_date IS NOT NULL
1294: AND H.marketing_source_code_id = C.source_code_id
1295: AND EXISTS (
1296: SELECT 1 FROM dual WHERE H.flow_status_code = G_BOOKED
1297: and rownum = 1
1298: UNION ALL
1299: SELECT 1 FROM OE_SYSTEM_PARAMETERS_ALL ospa, MTL_SYSTEM_ITEMS_B item
1300: WHERE H.org_id = ospa.org_id

Line 2332: SELECT 1 FROM dual WHERE H.flow_status_code = 'BOOKED'

2328: AND A.party_id = list_parties.party_id
2329: ) H
2330: WHERE H.header_id = I.header_id(+)
2331: AND EXISTS (
2332: SELECT 1 FROM dual WHERE H.flow_status_code = 'BOOKED'
2333: UNION ALL
2334: SELECT 1
2335: FROM OE_SYSTEM_PARAMETERS_ALL ospa, MTL_SYSTEM_ITEMS_B item
2336: WHERE H.org_id = ospa.org_id