APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PER_ALL_PEOPLE_F

Line 5119: x_agent_name per_all_people_f.full_name%TYPE;

5115: x_user_name fnd_user.user_name%TYPE;
5116: x_bid_number pon_bid_headers.bid_number%TYPE;
5117: x_vendor_name po_vendors.vendor_name%TYPE;
5118: x_vendor_site_name po_vendor_sites_all.vendor_site_code%TYPE;
5119: x_agent_name per_all_people_f.full_name%TYPE;
5120: x_order_number pon_bid_headers.order_number%TYPE;
5121: po_status varchar2(4000);
5122: msgBid varchar2(2000);
5123: msgSupplier varchar2(2000);

Line 5151: per_all_people_f papf

5147: papf.full_name,
5148: pbh.order_number
5149: FROM pon_bid_headers pbh,
5150: po_vendors pov,
5151: per_all_people_f papf
5152: WHERE pbh.auction_header_id = x_auction_header_id
5153: AND pbh.bid_status = 'ACTIVE'
5154: AND pbh.po_header_id is NOT NULL
5155: AND pbh.po_wf_creation_rnd = x_round_number

Line 5160: from per_all_people_f papf2

5156: AND pbh.vendor_id = pov.vendor_id
5157: AND pbh.agent_id = papf.person_id
5158: AND papf.effective_start_date < sysdate
5159: AND papf.effective_end_date = (select max(papf2.effective_end_date)
5160: from per_all_people_f papf2
5161: where papf2.person_id = pbh.agent_id)
5162: GROUP BY
5163: pbh.bid_number,
5164: pov.vendor_name,

Line 5284: x_agent_name per_all_people_f.full_name%TYPE;

5280: x_user_name fnd_user.user_name%TYPE;
5281: x_bid_number NUMBER;
5282: x_vendor_name po_vendors.vendor_name%TYPE;
5283: x_vendor_site_name po_vendor_sites_all.vendor_site_code%TYPE;
5284: x_agent_name per_all_people_f.full_name%TYPE;
5285: x_order_number pon_bid_headers.order_number%TYPE;
5286: x_error_code pon_bid_headers.po_error_code%TYPE;
5287: po_status varchar2(4000);
5288: msgBid varchar2(2000);

Line 5320: per_all_people_f papf

5316: pbh.po_error_msg
5317: FROM pon_bid_headers pbh,
5318: po_vendors pov,
5319: po_vendor_sites_all povsa,
5320: per_all_people_f papf
5321: WHERE pbh.auction_header_id = x_auction_header_id
5322: AND pbh.bid_status = 'ACTIVE'
5323: AND nvl(pbh.award_status, 'NO') in ('AWARDED', 'PARTIAL')
5324: AND pbh.po_header_id is NULL

Line 5330: from per_all_people_f papf2

5326: AND pbh.vendor_id = povsa.vendor_id
5327: AND pbh.agent_id = papf.person_id
5328: AND papf.effective_start_date < sysdate
5329: AND papf.effective_end_date = (select max(papf2.effective_end_date)
5330: from per_all_people_f papf2
5331: where papf2.person_id = pbh.agent_id)
5332: GROUP BY
5333: pbh.bid_number,
5334: pov.vendor_name,