DBA Data[Home] [Help]

APPS.PO_RCOTOLERANCE_PVT dependencies on DUAL

Line 575: FROM dual

571:
572: BEGIN
573: SELECT 'N'
574: INTO l_return_val
575: FROM dual
576: WHERE EXISTS (SELECT 'N'
577: FROM po_change_requests
578: WHERE change_request_group_id = p_reqgrp_id
579: AND action_type = 'MODIFICATION'

Line 600: FROM dual

596: ELSE
597: BEGIN
598: SELECT 'N'
599: INTO l_return_val
600: FROM dual
601: WHERE EXISTS (SELECT 'N'
602: FROM po_change_requests
603: WHERE change_request_group_id = p_reqgrp_id
604: AND action_type = 'MODIFICATION'

Line 647: FROM dual

643: END IF;
644:
645: SELECT 'N'
646: INTO l_return_val
647: FROM dual
648: WHERE EXISTS (SELECT 'N' FROM (
649: SELECT PRL.UNIT_PRICE AS UNIT_PRICE, PRL.QUANTITY AS QUANTITY,PCR.NEW_QUANTITY AS NEW_QUANTITY
650: FROM PO_CHANGE_REQUESTS PCR,
651: PO_REQUISITION_LINES_ALL PRL

Line 676: FROM dual

672: ELSE
673:
674: SELECT 'N'
675: INTO l_return_val
676: FROM dual
677: WHERE EXISTS (SELECT 'N'
678: FROM po_change_requests pcr,
679: po_change_requests pcr1,
680: po_requisition_lines_all prl,