APPS.WIP_OPERATION_RESOURCES_PKG dependencies on DUAL

Line 89: from dual

85: c_resource_seq_num number,
86: c_first_schedule_id number,
87: c_resource_id number) is
88: select 'X'
89: from dual
90: where c_resource_id =
91: (select resource_id
92: from wip_operation_resources
93: where organization_id = c_org_id

Line 249: FROM DUAL

245: p_rep_sched_id IN NUMBER) RETURN BOOLEAN IS
246:
247: CURSOR disc_check_po_req_cur IS
248: SELECT 'No PO/REQ Linked'
249: FROM DUAL
250: WHERE NOT EXISTS
251: (SELECT '1'
252: FROM PO_DISTRIBUTIONS_ALL PD,
253: WIP_OPERATION_RESOURCES WOR

Line 292: FROM DUAL

288: AND WOR.RESOURCE_SEQ_NUM = p_resource_seq_num);
289:
290: CURSOR rep_check_po_req_cur IS
291: SELECT 'No PO/REQ Linked'
292: FROM DUAL
293: WHERE NOT EXISTS
294: (SELECT '1'
295: FROM PO_DISTRIBUTIONS_ALL PD,
296: WIP_OPERATION_RESOURCES WOR