DBA Data[Home] [Help]

APPS.PO_RCOTOLERANCE_PVT dependencies on DUAL

Line 578: FROM dual

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

Line 603: FROM dual

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

Line 650: FROM dual

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

Line 679: FROM dual

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