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 541: from dual

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

Line 561: from dual

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

Line 585: from dual

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