DBA Data[Home] [Help]

APPS.AHL_OSP_PO_PVT dependencies on PO_AGENTS_NAME_V

Line 1380: SELECT 'x' FROM PO_AGENTS_NAME_V

1376: AND VENDOR_SITE_ID = p_supp_site_id;
1377: -- May have to check INACTIVE_DATE > SYSDATE also?
1378:
1379: CURSOR l_validate_buyer_csr(p_buyer_id IN NUMBER) IS
1380: SELECT 'x' FROM PO_AGENTS_NAME_V
1381: WHERE BUYER_ID = p_buyer_id;
1382: -- NOTE: Effective Date filtering is done by the PO_AGENTS_NAME_V view itself
1383:
1384: l_dummy VARCHAR2(1);

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

1378:
1379: CURSOR l_validate_buyer_csr(p_buyer_id IN NUMBER) IS
1380: SELECT 'x' FROM PO_AGENTS_NAME_V
1381: WHERE BUYER_ID = p_buyer_id;
1382: -- NOTE: Effective Date filtering is done by the PO_AGENTS_NAME_V view itself
1383:
1384: l_dummy VARCHAR2(1);
1385: l_temp_count NUMBER;
1386: l_org_id NUMBER := NULL;