APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKX_PAYABLES_TERMS_V

Line 4623: FROM okx_payables_terms_v

4619:
4620: CURSOR term_csr (p_payment_term VARCHAR2,
4621: p_payment_term_id NUMBER) IS
4622: SELECT id1
4623: FROM okx_payables_terms_v
4624: WHERE (name = p_payment_term
4625: AND
4626: p_payment_term IS NOT NULL)
4627: OR (id1 = p_payment_term_id

Line 4633: l_id1 OKX_PAYABLES_TERMS_V.ID1%TYPE;

4629: p_payment_term_id IS NOT NULL)
4630: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date_active),TRUNC(SYSDATE))
4631: AND NVL(TRUNC(end_date_active), TRUNC(SYSDATE));
4632:
4633: l_id1 OKX_PAYABLES_TERMS_V.ID1%TYPE;
4634: BEGIN
4635:
4636: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4637:

Line 5400: l_payment_term_id okx_payables_terms_v.id1%TYPE;

5396: l_rgp_id NUMBER;
5397: x_base_uom_id okx_tuom_v.id1%TYPE;
5398: x_price_list_id okx_list_headers_v.id1%TYPE;
5399: x_stream_id okl_strmtyp_source_v.id1%TYPE;
5400: l_payment_term_id okx_payables_terms_v.id1%TYPE;
5401: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;
5402: l_freq_id okl_time_units_v.id1%TYPE;
5403:
5404: -- Rule Rec

Line 5959: l_payment_term_id okx_payables_terms_v.id1%TYPE;

5955: x_usage_id2 okx_system_items_v.id2%TYPE;
5956: x_base_uom_id okx_tuom_v.id1%TYPE;
5957: x_price_list_id okx_list_headers_v.id1%TYPE;
5958: x_stream_id okl_strmtyp_source_v.id1%TYPE;
5959: l_payment_term_id okx_payables_terms_v.id1%TYPE;
5960: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;
5961: l_freq_id okl_time_units_v.id1%TYPE;
5962:
5963: CURSOR freq_csr (p_frequency VARCHAR2) IS

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

26912: WHERE vendor_site_code = p_code
26913: AND vendor_id = p_ven_id
26914: AND org_id = p_org;
26915:
26916: CURSOR payterm_csr (p_name okx_payables_terms_v.name%TYPE) IS
26917: SELECT id1
26918: FROM okx_payables_terms_v
26919: WHERE NAME = p_name
26920: AND status = 'A';

Line 26918: FROM okx_payables_terms_v

26914: AND org_id = p_org;
26915:
26916: CURSOR payterm_csr (p_name okx_payables_terms_v.name%TYPE) IS
26917: SELECT id1
26918: FROM okx_payables_terms_v
26919: WHERE NAME = p_name
26920: AND status = 'A';
26921:
26922: BEGIN