APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_TIME_UNITS_V

Line 2811: FROM okl_time_units_v

2807: */
2808: CURSOR freq_csr (p_payment_freq_code okl_payments_interface.payment_frequency_code%TYPE) IS
2809: SELECT id1,
2810: id1
2811: FROM okl_time_units_v
2812: WHERE name = p_payment_freq_code;
2813:
2814: l_id1 okx_tuom_v.id1%TYPE;
2815: l_uom_code okx_tuom_v.uom_code%TYPE;

Line 5570: l_freq_id okl_time_units_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
5573: x_rgpv_rec rgpv_rec_type;
5574: l_rgpv_rec rgpv_rec_type;

Line 6129: l_freq_id okl_time_units_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
6132: SELECT id1
6133: FROM okl_time_units_v

Line 6133: FROM okl_time_units_v

6129: l_freq_id okl_time_units_v.id1%TYPE;
6130:
6131: CURSOR freq_csr (p_frequency VARCHAR2) IS
6132: SELECT id1
6133: FROM okl_time_units_v
6134: WHERE name = p_frequency
6135: AND status = 'A'
6136: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date_active), TRUNC(SYSDATE)) AND
6137: NVL(TRUNC(end_date_active), TRUNC(SYSDATE));