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 528: l_investor_name PO_VENDORS.vendor_name%TYPE;

524: l_amnt_to_be_disbursed NUMBER;
525: l_sty_id okl_strm_type_v.id%TYPE;
526: l_try_id okl_trx_types_v.id%TYPE;
527: l_payout_date DATE;
528: l_investor_name PO_VENDORS.vendor_name%TYPE;
529: l_investor_site_code PO_VENDOR_SITES.vendor_site_code%TYPE;
530: l_strm_name OKL_STRM_TYPE_V.name%TYPE;
531:
532: l_ia_id okl_k_headers_full_v.id%type;

Line 591: -- Get Vendor Name from PO_Vendors_All

587: l_pay_group_code;
588: CLOSE vendor_attrs_csr;
589:
590: ----------------------------------------
591: -- Get Vendor Name from PO_Vendors_All
592: ----------------------------------------
593: l_investor_name := NULL;
594: OPEN vendor_name_csr ( l_pay_to_id );
595: FETCH vendor_name_csr INTO l_investor_name;

Line 976: l_investor_name PO_VENDORS.vendor_name%TYPE;

972: AND CLET.LSE_ID = LSET.ID
973: AND LSET.LTY_CODE = 'INVESTMENT'
974: ORDER BY 1;
975:
976: l_investor_name PO_VENDORS.vendor_name%TYPE;
977: l_investor_site_code PO_VENDOR_SITES.vendor_site_code%TYPE;
978:
979: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
980: -- CURSOR rcpts_csr ( p_lsm_id NUMBER,

Line 1690: -- Get Vendor Name from PO_Vendors_All

1686: CLOSE vendor_attrs_csr;
1687:
1688: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ### 15 ### ');
1689: ----------------------------------------
1690: -- Get Vendor Name from PO_Vendors_All
1691: ----------------------------------------
1692: l_investor_name := NULL;
1693: OPEN vendor_name_csr ( l_investor_id );
1694: FETCH vendor_name_csr INTO l_investor_name;