DBA Data[Home] [Help]

APPS.FLM_EXECUTION_UTIL dependencies on DUAL

Line 1228: from dual

1224: x_returnStatus out nocopy varchar2) is
1225:
1226: CURSOR sub_exist(p_org_id NUMBER, p_wip_ent_id NUMBER) IS
1227: select 1 as subs
1228: from dual
1229: where exists (
1230: select inventory_item_id
1231: from flm_exe_req_operations
1232: where organization_id = p_org_id

Line 1651: from dual

1647: RETURN NUMBER IS
1648: l_exists NUMBER := 0;
1649: CURSOR kanban_card_csr(l_wip_entity_id IN NUMBER) IS
1650: select 1 as kanban_exists
1651: from dual
1652: where exists
1653: (select kanban_card_id
1654: from mtl_kanban_card_activity
1655: where source_wip_entity_id = l_wip_entity_id