DBA Data[Home] [Help]

APPS.AHL_OSP_PO_PVT dependencies on PO_AGENTS_NAME_V

Line 1388: SELECT 'x' FROM PO_AGENTS_NAME_V

1384: AND VENDOR_SITE_ID = p_supp_site_id;
1385: -- May have to check INACTIVE_DATE > SYSDATE also?
1386:
1387: CURSOR l_validate_buyer_csr(p_buyer_id IN NUMBER) IS
1388: SELECT 'x' FROM PO_AGENTS_NAME_V
1389: WHERE BUYER_ID = p_buyer_id;
1390: -- NOTE: Effective Date filtering is done by the PO_AGENTS_NAME_V view itself
1391:
1392: l_dummy VARCHAR2(1);

Line 1390: -- NOTE: Effective Date filtering is done by the PO_AGENTS_NAME_V view itself

1386:
1387: CURSOR l_validate_buyer_csr(p_buyer_id IN NUMBER) IS
1388: SELECT 'x' FROM PO_AGENTS_NAME_V
1389: WHERE BUYER_ID = p_buyer_id;
1390: -- NOTE: Effective Date filtering is done by the PO_AGENTS_NAME_V view itself
1391:
1392: l_dummy VARCHAR2(1);
1393: l_temp_count NUMBER;
1394: l_org_id NUMBER := NULL;