APPS.AHL_OSP_ORDERS_PVT dependencies on PO_AGENTS_NAME_V

Line 289: SELECT buyer_id FROM po_agents_name_v

285: AND purchasing_site_flag = G_YES_FLAG;
286: l_vendor_site_id NUMBER;
287:
288: CURSOR po_agent_id_csr(p_buyer_name IN VARCHAR2) IS
289: SELECT buyer_id FROM po_agents_name_v
290: WHERE full_name = p_buyer_name;
291: l_po_agent_id NUMBER;
292: CURSOR customer_id_csr(p_customer_name IN VARCHAR2) IS
293: SELECT party_id from hz_parties

Line 704: SELECT 'x' FROM po_agents_name_v

700: PROCEDURE validate_buyer(
701: p_po_agent_id IN NUMBER
702: )IS
703: CURSOR val_po_agent_id_csr(p_po_agent_id IN NUMBER) IS
704: SELECT 'x' FROM po_agents_name_v
705: WHERE buyer_id = p_po_agent_id;
706: l_exist VARCHAR2(1);
707: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.validate_buyer';
708: BEGIN

Line 3952: FROM po_agents_name_v PA,

3948: l_vendor_valid_flag BOOLEAN := FALSE;
3949:
3950: CURSOR get_buyer_id IS
3951: SELECT PA.buyer_id
3952: FROM po_agents_name_v PA,
3953: fnd_user FU
3954: WHERE FU.user_id = fnd_global.user_id
3955: AND PA.buyer_id = FU.employee_id;
3956: BEGIN