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'
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'
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
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,