APPS.PON_VALIDATE_PAYMENTS_INT dependencies on PON_AUC_PAYMENTS_SHIPMENTS

Line 567: -- pon_auc_payments_shipments and all the other validations don't need them.

563: END IF;
564:
565:
566: -- This validation is done in a separate sql as this one needs join to
567: -- pon_auc_payments_shipments and all the other validations don't need them.
568: INSERT INTO PON_INTERFACE_ERRORS
569: (
570: column_name, entity_attr_name, error_message_name, -- 1
571: error_value_datatype, error_value_number, error_value_date, -- 2

Line 603: FROM PON_AUC_PAYMENTS_SHIPMENTS pap

599: PON_AUCTION_HEADERS_ALL pah
600: WHERE pbp.document_disp_line_number = pai.document_disp_line_number
601: AND pbp.auction_header_id = pai.auction_header_id
602: AND pbp.payment_display_number NOT IN(SELECT pap.payment_display_number
603: FROM PON_AUC_PAYMENTS_SHIPMENTS pap
604: WHERE pap.auction_header_id=pbp.auction_header_id
605: AND pap.line_number=pai.line_number)
606: AND pah.auction_header_id = pbp.auction_header_id
607: AND pah.supplier_enterable_pymt_flag = 'N'