APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_TIME_UNITS_V

Line 2646: FROM okl_time_units_v

2642: */
2643: CURSOR freq_csr (p_payment_freq_code okl_payments_interface.payment_frequency_code%TYPE) IS
2644: SELECT id1,
2645: id1
2646: FROM okl_time_units_v
2647: WHERE name = p_payment_freq_code;
2648:
2649: l_id1 okx_tuom_v.id1%TYPE;
2650: l_uom_code okx_tuom_v.uom_code%TYPE;

Line 5402: l_freq_id okl_time_units_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
5405: x_rgpv_rec rgpv_rec_type;
5406: l_rgpv_rec rgpv_rec_type;

Line 5961: l_freq_id okl_time_units_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
5964: SELECT id1
5965: FROM okl_time_units_v

Line 5965: FROM okl_time_units_v

5961: l_freq_id okl_time_units_v.id1%TYPE;
5962:
5963: CURSOR freq_csr (p_frequency VARCHAR2) IS
5964: SELECT id1
5965: FROM okl_time_units_v
5966: WHERE name = p_frequency
5967: AND status = 'A'
5968: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date_active), TRUNC(SYSDATE)) AND
5969: NVL(TRUNC(end_date_active), TRUNC(SYSDATE));