APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on PO_VENDOR_SITES

Line 39: FROM po_vendor_sites

35: -- Cursor to fetch Vendor Site
36: -----------------------------------------------------------------
37: CURSOR vendor_site_csr ( p_vendor_site_id NUMBER ) IS
38: SELECT VENDOR_SITE_CODE
39: FROM po_vendor_sites
40: WHERE VENDOR_SITE_ID = p_vendor_site_id;
41:
42: -----------------------------------------------------------------
43: -- Cursor to fetch Org Id

Line 529: l_investor_site_code PO_VENDOR_SITES.vendor_site_code%TYPE;

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;
533: l_currency_code okl_k_headers_full_v.currency_code%TYPE;

Line 599: -- Get Vendor Site from po_vendor_sites

595: FETCH vendor_name_csr INTO l_investor_name;
596: CLOSE vendor_name_csr;
597:
598: ----------------------------------------
599: -- Get Vendor Site from po_vendor_sites
600: ----------------------------------------
601: l_investor_site_code := NULL;
602: OPEN vendor_site_csr ( l_pay_site_id );
603: FETCH vendor_site_csr INTO l_investor_site_code;

Line 977: l_investor_site_code PO_VENDOR_SITES.vendor_site_code%TYPE;

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,
981: --start:| 25-Jun-2008 cklee Fixed bug: 6784252 |

Line 1699: -- Get Vendor Site from po_vendor_sites

1695: CLOSE vendor_name_csr;
1696: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ### 16 ### ');
1697:
1698: ----------------------------------------
1699: -- Get Vendor Site from po_vendor_sites
1700: ----------------------------------------
1701: l_investor_site_code := NULL;
1702: OPEN vendor_site_csr ( l_investor_site_id );
1703: FETCH vendor_site_csr INTO l_investor_site_code;