DBA Data[Home] [Help]

APPS.PON_BID_DEFAULTING_PKG dependencies on PON_ACKNOWLEDGEMENTS

Line 3884: FROM pon_auction_headers_all ah, pon_acknowledgements ac

3880:
3881: -- There must be as many acknowledgements as amendments
3882: SELECT decode(count(rownum), 0, 'N', 'Y')
3883: INTO l_amend_not_acked
3884: FROM pon_auction_headers_all ah, pon_acknowledgements ac
3885: WHERE ah.auction_header_id_orig_amend = l_orig_amend_id
3886: AND ah.auction_status IN ('AMENDED', 'ACTIVE')
3887: -- ignore the original amendment
3888: AND ah.amendment_number > 0