APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on PO_VENDORS

Line 31: FROM po_vendors

27: -- Cursor to fetch Vendor Or Investor Name
28: -----------------------------------------------------------------
29: CURSOR vendor_name_csr ( p_vendor_id NUMBER ) IS
30: SELECT VENDOR_NAME
31: FROM po_vendors
32: WHERE VENDOR_ID = p_vendor_id;
33:
34: -----------------------------------------------------------------
35: -- Cursor to fetch Vendor Site

Line 513: l_investor_name PO_VENDORS.vendor_name%TYPE;

509: l_amnt_to_be_disbursed NUMBER;
510: l_sty_id okl_strm_type_v.id%TYPE;
511: l_try_id okl_trx_types_v.id%TYPE;
512: l_payout_date DATE;
513: l_investor_name PO_VENDORS.vendor_name%TYPE;
514: l_investor_site_code PO_VENDOR_SITES.vendor_site_code%TYPE;
515: l_strm_name OKL_STRM_TYPE_V.name%TYPE;
516:
517: l_ia_id okl_k_headers_full_v.id%type;

Line 576: -- Get Vendor Name from PO_Vendors_All

572: l_pay_group_code;
573: CLOSE vendor_attrs_csr;
574:
575: ----------------------------------------
576: -- Get Vendor Name from PO_Vendors_All
577: ----------------------------------------
578: l_investor_name := NULL;
579: OPEN vendor_name_csr ( l_pay_to_id );
580: FETCH vendor_name_csr INTO l_investor_name;

Line 961: l_investor_name PO_VENDORS.vendor_name%TYPE;

957: AND CLET.LSE_ID = LSET.ID
958: AND LSET.LTY_CODE = 'INVESTMENT'
959: ORDER BY 1;
960:
961: l_investor_name PO_VENDORS.vendor_name%TYPE;
962: l_investor_site_code PO_VENDOR_SITES.vendor_site_code%TYPE;
963:
964: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
965: -- CURSOR rcpts_csr ( p_lsm_id NUMBER,

Line 1620: -- Get Vendor Name from PO_Vendors_All

1616: CLOSE vendor_attrs_csr;
1617:
1618: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ### 15 ### ');
1619: ----------------------------------------
1620: -- Get Vendor Name from PO_Vendors_All
1621: ----------------------------------------
1622: l_investor_name := NULL;
1623: OPEN vendor_name_csr ( l_investor_id );
1624: FETCH vendor_name_csr INTO l_investor_name;