DBA Data[Home] [Help]

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 514: l_investor_site_code PO_VENDOR_SITES.vendor_site_code%TYPE;

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

Line 584: -- Get Vendor Site from po_vendor_sites

580: FETCH vendor_name_csr INTO l_investor_name;
581: CLOSE vendor_name_csr;
582:
583: ----------------------------------------
584: -- Get Vendor Site from po_vendor_sites
585: ----------------------------------------
586: l_investor_site_code := NULL;
587: OPEN vendor_site_csr ( l_pay_site_id );
588: FETCH vendor_site_csr INTO l_investor_site_code;

Line 962: l_investor_site_code PO_VENDOR_SITES.vendor_site_code%TYPE;

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

Line 1629: -- Get Vendor Site from po_vendor_sites

1625: CLOSE vendor_name_csr;
1626: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ### 16 ### ');
1627:
1628: ----------------------------------------
1629: -- Get Vendor Site from po_vendor_sites
1630: ----------------------------------------
1631: l_investor_site_code := NULL;
1632: OPEN vendor_site_csr ( l_investor_site_id );
1633: FETCH vendor_site_csr INTO l_investor_site_code;