DBA Data[Home] [Help]

APPS.IEX_OPI_PVT dependencies on PO_VENDOR_SITES_ALL

Line 3003: l_email PO_VENDOR_SITES_ALL.EMAIL_ADDRESS%TYPE;

2999: x_email OUT NOCOPY VARCHAR2,
3000: x_return_status OUT NOCOPY VARCHAR2) AS
3001:
3002: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3003: l_email PO_VENDOR_SITES_ALL.EMAIL_ADDRESS%TYPE;
3004:
3005: CURSOR l_ext_agncy_email_csr(cp_ext_agncy_id IN NUMBER) IS
3006: SELECT pvs.email_address
3007: FROM iex_ext_agncy_b iea

Line 3008: ,po_vendor_sites_all pvs

3004:
3005: CURSOR l_ext_agncy_email_csr(cp_ext_agncy_id IN NUMBER) IS
3006: SELECT pvs.email_address
3007: FROM iex_ext_agncy_b iea
3008: ,po_vendor_sites_all pvs
3009: WHERE iea.external_agency_id = cp_ext_agncy_id
3010: AND iea.vendor_site_id = pvs.vendor_site_id;
3011: BEGIN
3012: OPEN l_ext_agncy_email_csr(p_ext_agncy_id);