APPS.OKL_CONS_BILL dependencies on OKL_STRM_TYPE_V

Line 1059: okl_strm_type_v sty

1055: FROM okl_invoice_formats_v inf,
1056: okl_invoice_types_v ity,
1057: okl_invc_line_types_v ilt,
1058: okl_invc_frmt_strms_v frs,
1059: okl_strm_type_v sty
1060: WHERE inf.id = p_format_id
1061: AND ity.inf_id = inf.id
1062: AND ilt.ity_id = ity.id
1063: AND frs.ilt_id = ilt.id

Line 1088: l_sty_name OKL_STRM_TYPE_V.NAME%TYPE;

1084: AND inf.ilt_id = ilt.id;
1085:
1086: l_cons_invoice_num OKL_CNSLD_AR_HDRS_B.CONSOLIDATED_INVOICE_NUMBER%TYPE;
1087: l_invoice_format OKL_INVOICE_FORMATS_V.NAME%TYPE;
1088: l_sty_name OKL_STRM_TYPE_V.NAME%TYPE;
1089:
1090: l_old_cnr_id NUMBER;
1091: l_old_lln_id NUMBER;
1092: l_cnt NUMBER;

Line 1112: FROM okl_strm_type_v

1108: lln.id = lsm.lln_id;
1109:
1110: CURSOR strm_csr ( p_id NUMBER ) IS
1111: SELECT name
1112: FROM okl_strm_type_v
1113: WHERE id = p_id;
1114:
1115: BEGIN
1116: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 2027: FROM okl_strm_type_v

2023: WHERE id = p_id;
2024:
2025: CURSOR strm_csr ( p_id NUMBER ) IS
2026: SELECT name
2027: FROM okl_strm_type_v
2028: WHERE id = p_id;
2029:
2030: l_contract_number okc_k_headers_b.contract_number%TYPE;
2031: l_stream_name1 okl_strm_type_v.name%TYPE;

Line 2031: l_stream_name1 okl_strm_type_v.name%TYPE;

2027: FROM okl_strm_type_v
2028: WHERE id = p_id;
2029:
2030: l_contract_number okc_k_headers_b.contract_number%TYPE;
2031: l_stream_name1 okl_strm_type_v.name%TYPE;
2032:
2033: l_temp_khr_id NUMBER;
2034:
2035: CURSOR get_khr_id ( p_lsm_id NUMBER ) IS

Line 3046: okl_strm_type_v sty

3042: BEGIN
3043: SELECT sty.name
3044: INTO l_xlsv_rec.XTRX_STREAM_TYPE
3045: FROM okl_cnsld_ar_strms_v lsm,
3046: okl_strm_type_v sty
3047: WHERE lsm.id = cnr_update_tbl(cnr_tab_idx).lsm_id AND
3048: sty.id = lsm.sty_id;
3049: EXCEPTION
3050: WHEN OTHERS THEN