APPS.PON_NEW_SUPPLIER_REG_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 36: l_org_id PON_AUCTION_HEADERS_ALL.ORG_ID%TYPE;

32:
33: TYPE VARCHAR2_WF_ROLE_TYPE IS TABLE OF VARCHAR2(320) INDEX BY BINARY_INTEGER;
34: l_wf_role_name VARCHAR2_WF_ROLE_TYPE;
35:
36: l_org_id PON_AUCTION_HEADERS_ALL.ORG_ID%TYPE;
37: l_party_id PON_BIDDING_PARTIES.TRADING_PARTNER_ID%TYPE;
38: l_vendor_contact_id PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_ID%TYPE;
39: l_user_name FND_USER.USER_NAME%TYPE;
40: --

Line 122: FROM pon_bidding_parties pbp, pon_auction_headers_all ah

118: -- and update pon_bidding_parties to null out wf_user_name
119:
120: SELECT DISTINCT ah.auction_header_id, ah.wf_role_name
121: BULK COLLECT INTO l_auction_header_id, l_wf_role_name
122: FROM pon_bidding_parties pbp, pon_auction_headers_all ah
123: WHERE pbp.trading_partner_contact_id = l_vendor_contact_id
124: AND pbp.wf_user_name IS NOT NULL
125: AND pbp.auction_header_id = ah.auction_header_id;
126: