DBA Data[Home] [Help]

APPS.AHL_OSP_PO_REQ_PVT dependencies on PO_AGENTS_NAME_V

Line 1126: SELECT 'x' FROM PO_AGENTS_NAME_V

1122: AND VENDOR_SITE_ID = p_supp_site_id;
1123: -- May have to check INACTIVE_DATE > SYSDATE also?
1124:
1125: CURSOR l_validate_buyer_csr(p_buyer_id IN NUMBER) IS
1126: SELECT 'x' FROM PO_AGENTS_NAME_V
1127: WHERE BUYER_ID = p_buyer_id;
1128: -- NOTE: Effective Date filtering is done by the PO_AGENTS_NAME_V view itself
1129:
1130: l_dummy VARCHAR2(1);

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

1124:
1125: CURSOR l_validate_buyer_csr(p_buyer_id IN NUMBER) IS
1126: SELECT 'x' FROM PO_AGENTS_NAME_V
1127: WHERE BUYER_ID = p_buyer_id;
1128: -- NOTE: Effective Date filtering is done by the PO_AGENTS_NAME_V view itself
1129:
1130: l_dummy VARCHAR2(1);
1131: l_temp_count NUMBER;
1132: l_org_id NUMBER := NULL;