APPS.PO_DISTRIBUTIONS_SV dependencies on DUAL

Line 96: FROM dual

92: -- with same distribution num for a shipment
93:
94: SELECT 'unique'
95: INTO l_dummy
96: FROM dual
97: WHERE NOT EXISTS
98: ( SELECT 1
99: FROM po_distributions
100: WHERE line_location_id = p_line_location_id

Line 540: from dual

536: /* Find if any record for the shipment exists in rcv_transactions table */
537: begin
538: select 'Y'
539: into l_exists
540: from dual
541: where exists
542: (select 'rcv transaction records'
543: from rcv_transactions
544: where po_line_location_id = p_line_location_id);

Line 560: from dual

556:
557: begin
558: select 'Y'
559: into l_exists
560: from dual
561: where exists
562: (select 'transaction interface records'
563: from rcv_transactions_interface
564: where po_line_location_id = p_line_location_id

Line 584: from dual

580: */
581: begin
582: select 'Y'
583: into l_exists
584: from dual
585: where exists
586: (select 'Active invoice distributions'
587: from ap_invoice_distributions
588: where po_distribution_id = p_distribution_id