APPS.PON_AWARD_PKG dependencies on PON_BACKING_REQUISITIONS

Line 718: SELECT Count(*) FROM pon_backing_requisitions

714: WHERE auction_header_id = p_auction_header_id;
715:
716: --Line Type and Structute Changes Project
717: CURSOR c_has_linked_pr_refs IS
718: SELECT Count(*) FROM pon_backing_requisitions
719: WHERE auction_header_id = p_auction_header_id;
720:
721: l_linked_pr_refs_count NUMBER;
722:

Line 5565: Procedure to copy all backing requisition Associated to SOl lines from pon_backing_requisitions to pon_bid_backing_requisitions.*/

5561: RETURN 0;
5562: END GET_SAVING_PERCENT_INCENTIVE;
5563:
5564: /*Line Type and Structure Changes Project:
5565: Procedure to copy all backing requisition Associated to SOl lines from pon_backing_requisitions to pon_bid_backing_requisitions.*/
5566:
5567: PROCEDURE create_pon_bid_back_req(p_auction_header_id IN NUMBER)
5568: IS
5569:

Line 5616: FROM pon_auction_item_prices_all paip, pon_backing_requisitions pbr

5612: sysdate,
5613: l_user_id,
5614: l_login_id,
5615: SYSDATE
5616: FROM pon_auction_item_prices_all paip, pon_backing_requisitions pbr
5617: WHERE pbr.auction_header_id = p_auction_header_id
5618: AND paip.auction_header_id = pbr.auction_header_id
5619: AND paip.line_number = pbr.line_number);
5620: