APPS.FLM_EXECUTION_UTIL dependencies on DUAL

Line 1448: from dual

1444: x_returnStatus out nocopy varchar2) is
1445:
1446: CURSOR sub_exist(p_org_id NUMBER, p_wip_ent_id NUMBER) IS
1447: select 1 as subs
1448: from dual
1449: where exists (
1450: select inventory_item_id
1451: from flm_exe_req_operations
1452: where organization_id = p_org_id

Line 1871: from dual

1867: RETURN NUMBER IS
1868: l_exists NUMBER := 0;
1869: CURSOR kanban_card_csr(l_wip_entity_id IN NUMBER) IS
1870: select 1 as kanban_exists
1871: from dual
1872: where exists
1873: (select kanban_card_id
1874: from mtl_kanban_card_activity
1875: where source_wip_entity_id = l_wip_entity_id

Line 2245: from dual

2241:
2242:
2243: CURSOR event_exist_csr IS
2244: select 'Y' as event_exist
2245: from dual
2246: where exists (
2247: select bos.operation_sequence_id
2248: from bom_operation_sequences bos
2249: where bos.routing_sequence_id = l_common_routing_seq_id