APPS.WIP_SUB_OP_RESOURCES_PKG dependencies on DUAL

Line 91: from dual

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

Line 251: FROM DUAL

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

Line 294: FROM DUAL

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