APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKX_PAYABLES_TERMS_V

Line 4791: FROM okx_payables_terms_v

4787:
4788: CURSOR term_csr (p_payment_term VARCHAR2,
4789: p_payment_term_id NUMBER) IS
4790: SELECT id1
4791: FROM okx_payables_terms_v
4792: WHERE (name = p_payment_term
4793: AND
4794: p_payment_term IS NOT NULL)
4795: OR (id1 = p_payment_term_id

Line 4801: l_id1 OKX_PAYABLES_TERMS_V.ID1%TYPE;

4797: p_payment_term_id IS NOT NULL)
4798: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date_active),TRUNC(SYSDATE))
4799: AND NVL(TRUNC(end_date_active), TRUNC(SYSDATE));
4800:
4801: l_id1 OKX_PAYABLES_TERMS_V.ID1%TYPE;
4802: BEGIN
4803:
4804: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4805:

Line 5568: l_payment_term_id okx_payables_terms_v.id1%TYPE;

5564: l_rgp_id NUMBER;
5565: x_base_uom_id okx_tuom_v.id1%TYPE;
5566: x_price_list_id okx_list_headers_v.id1%TYPE;
5567: x_stream_id okl_strmtyp_source_v.id1%TYPE;
5568: l_payment_term_id okx_payables_terms_v.id1%TYPE;
5569: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;
5570: l_freq_id okl_time_units_v.id1%TYPE;
5571:
5572: -- Rule Rec

Line 6127: l_payment_term_id okx_payables_terms_v.id1%TYPE;

6123: x_usage_id2 okx_system_items_v.id2%TYPE;
6124: x_base_uom_id okx_tuom_v.id1%TYPE;
6125: x_price_list_id okx_list_headers_v.id1%TYPE;
6126: x_stream_id okl_strmtyp_source_v.id1%TYPE;
6127: l_payment_term_id okx_payables_terms_v.id1%TYPE;
6128: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;
6129: l_freq_id okl_time_units_v.id1%TYPE;
6130:
6131: CURSOR freq_csr (p_frequency VARCHAR2) IS

Line 27188: CURSOR payterm_csr (p_name okx_payables_terms_v.name%TYPE) IS

27184: WHERE vendor_site_code = p_code
27185: AND vendor_id = p_ven_id
27186: AND org_id = p_org;
27187:
27188: CURSOR payterm_csr (p_name okx_payables_terms_v.name%TYPE) IS
27189: SELECT id1
27190: FROM okx_payables_terms_v
27191: WHERE NAME = p_name
27192: AND status = 'A';

Line 27190: FROM okx_payables_terms_v

27186: AND org_id = p_org;
27187:
27188: CURSOR payterm_csr (p_name okx_payables_terms_v.name%TYPE) IS
27189: SELECT id1
27190: FROM okx_payables_terms_v
27191: WHERE NAME = p_name
27192: AND status = 'A';
27193:
27194: BEGIN