APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PER_ALL_PEOPLE_F

Line 4137: x_agent_name per_all_people_f.full_name%TYPE;

4133: x_user_name fnd_user.user_name%TYPE;
4134: x_bid_number pon_bid_headers.bid_number%TYPE;
4135: x_vendor_name po_vendors.vendor_name%TYPE;
4136: x_vendor_site_name po_vendor_sites_all.vendor_site_code%TYPE;
4137: x_agent_name per_all_people_f.full_name%TYPE;
4138: x_order_number pon_bid_headers.order_number%TYPE;
4139: po_status varchar2(4000);
4140: msgBid varchar2(2000);
4141: msgSupplier varchar2(2000);

Line 4169: per_all_people_f papf

4165: papf.full_name,
4166: pbh.order_number
4167: FROM pon_bid_headers pbh,
4168: po_vendors pov,
4169: per_all_people_f papf
4170: WHERE pbh.auction_header_id = x_auction_header_id
4171: AND pbh.bid_status = 'ACTIVE'
4172: AND pbh.po_header_id is NOT NULL
4173: AND pbh.po_wf_creation_rnd = x_round_number

Line 4178: from per_all_people_f papf2

4174: AND pbh.vendor_id = pov.vendor_id
4175: AND pbh.agent_id = papf.person_id
4176: AND papf.effective_start_date < sysdate
4177: AND papf.effective_end_date = (select max(papf2.effective_end_date)
4178: from per_all_people_f papf2
4179: where papf2.person_id = pbh.agent_id)
4180: GROUP BY
4181: pbh.bid_number,
4182: pov.vendor_name,

Line 4299: x_agent_name per_all_people_f.full_name%TYPE;

4295: x_user_name fnd_user.user_name%TYPE;
4296: x_bid_number NUMBER;
4297: x_vendor_name po_vendors.vendor_name%TYPE;
4298: x_vendor_site_name po_vendor_sites_all.vendor_site_code%TYPE;
4299: x_agent_name per_all_people_f.full_name%TYPE;
4300: x_order_number pon_bid_headers.order_number%TYPE;
4301: x_error_code pon_bid_headers.po_error_code%TYPE;
4302: po_status varchar2(4000);
4303: msgBid varchar2(2000);

Line 4335: per_all_people_f papf

4331: pbh.po_error_msg
4332: FROM pon_bid_headers pbh,
4333: po_vendors pov,
4334: po_vendor_sites_all povsa,
4335: per_all_people_f papf
4336: WHERE pbh.auction_header_id = x_auction_header_id
4337: AND pbh.bid_status = 'ACTIVE'
4338: AND nvl(pbh.award_status, 'NO') in ('AWARDED', 'PARTIAL')
4339: AND pbh.po_header_id is NULL

Line 4345: from per_all_people_f papf2

4341: AND pbh.vendor_id = povsa.vendor_id
4342: AND pbh.agent_id = papf.person_id
4343: AND papf.effective_start_date < sysdate
4344: AND papf.effective_end_date = (select max(papf2.effective_end_date)
4345: from per_all_people_f papf2
4346: where papf2.person_id = pbh.agent_id)
4347: GROUP BY
4348: pbh.bid_number,
4349: pov.vendor_name,