APPS.BOM_OPRESOURCE_PVT dependencies on DUAL

Line 333: From dual

329: rate_invalid NUMBER;
330: --
331: cursor l_operation_csr(P_OpSeqId number) is
332: Select 'x' dummy
333: From dual
334: Where not exists(
335: select null
336: from bom_operation_sequences
337: where operation_sequence_id = P_OpSeqId

Line 342: from dual

338: and nvl(operation_type, g_event) = g_event
339: and nvl(reference_flag, g_no) = g_no);
340: cursor l_resource_csr(P_OpSeqId number, P_ResourceId number) is
341: select 'x' dummy
342: from dual
343: where not exists (
344: select null
345: from bom_resources br,
346: bom_department_resources bdr,

Line 366: From dual

362: and bdr.department_id = bos.department_id
363: and bdr.department_id = bd.department_id;
364: cursor l_activity_csr(P_ActivityId number, P_OpSeqId number) is
365: Select 'x' dummy
366: From dual
367: Where not exists(
368: select null
369: from cst_activities ca,
370: bom_operation_sequences bos,

Line 383: From dual

379: > bos.effectivity_date);
380: cursor l_DupResource_csr(P_OpSeqId number, P_OldSeqNum number,
381: P_NewSeqNum number) is
382: Select 'x' dummy
383: From dual
384: Where exists(
385: Select null
386: from bom_operation_resources bor
387: where bor.operation_sequence_id = P_OpSeqId

Line 405: From dual

401: From mtl_units_of_measure
402: Where uom_code = P_Code;
403: cursor l_conversion_csr is
404: Select 'x' dummy
405: From dual
406: where not exists(
407: select null
408: from mtl_uom_conversions a,
409: mtl_uom_conversions b

Line 420: From dual

416: and b.uom_class = a.uom_class);
417: cursor l_schedule_csr(P_OpSeqId number, P_SeqNum number,
418: P_SchedType number) is
419: Select 'x' dummy
420: From dual
421: Where exists(
422: select null
423: from bom_operation_resources bor
424: where operation_sequence_id = P_OpSeqId

Line 434: from dual

430: l_POReceipt constant number := 3;
431: l_POMove constant number := 4;
432: cursor l_pomove_csr(P_OpSeqId number, P_SeqNum number) is
433: select 'x' dummy
434: from dual
435: where exists(
436: select null
437: from bom_operation_resources
438: where operation_sequence_id = P_OpSeqId

Line 444: from dual

440: resource_seq_num <> P_SeqNum)
441: and autocharge_type = l_POMove);
442: cursor l_CheckLocation_csr(P_OpSeqId number) is
443: select 1 dummy
444: from dual
445: where not exists(
446: select 'no dept loc'
447: from bom_departments bd,
448: bom_operation_sequences bos