APPS.OKL_PROCESS_STREAMS_PVT dependencies on OKL_STRM_TYPE_B

Line 131: okl_strm_type_b sty

127: okc_k_headers_b chr,
128: okc_k_lines_b cle,
129: okc_line_styles_b lse,
130: okc_k_items cim,
131: okl_strm_type_b sty
132: where
133: chr.id = p_khr_id
134: and chr.id = cle.dnz_chr_id
135: and cle.lse_id = lse.id

Line 154: OKL_STRM_TYPE_B STYB

150: OKC_K_HEADERS_B KHRB,
151: OKC_RULE_GROUPS_B CRGB,
152: OKC_RULES_B CRLB,
153: OKC_K_LINES_V KLIN,
154: OKL_STRM_TYPE_B STYB
155: WHERE
156: KHRB.ID = p_khr_id
157: AND CRGB.DNZ_CHR_ID = KHRB.ID
158: AND CRGB.RGD_CODE = 'LALEVL'

Line 649: OKL_STRM_TYPE_B STREAM_TYPE,

645: TO_NUMBER(NULL) KLE_ID
646: FROM
647: OKL_SIF_RET_STRMS RETURN_STREAMS,
648: OKL_SIF_RETS RETURN_HEADER,
649: OKL_STRM_TYPE_B STREAM_TYPE,
650: OKL_STREAM_INTERFACES HEADER
651: WHERE
652: RETURN_HEADER.id = RETURN_STREAMS.sir_id
653: AND RETURN_HEADER.transaction_number =p_trx_number

Line 674: OKL_STRM_TYPE_B STREAM_TYPE,

670: -- select kle_fee_id as well from the OKL_SIF_FEES table
671: FEES.KLE_ID KLE_ID
672: -- TO_NUMBER(NULL)
673: FROM
674: OKL_STRM_TYPE_B STREAM_TYPE,
675: OKL_SIF_RET_STRMS RETURN_STREAMS,
676: OKL_SIF_RETS RETURN_HEADER,
677: OKL_STREAM_INTERFACES HEADER,
678: -- OKL_SIF_LINES LINES,

Line 728: OKL_STRM_TYPE_B STREAM_TYPE,

724: HEADER.KHR_ID,
725:
726: LINES.KLE_ID KLE_ID
727: FROM
728: OKL_STRM_TYPE_B STREAM_TYPE,
729: OKL_SIF_RET_STRMS RETURN_STREAMS,
730: OKL_SIF_RETS RETURN_HEADER,
731: OKL_STREAM_INTERFACES HEADER,
732: OKL_SIF_LINES LINES,

Line 774: OKL_STRM_TYPE_B STREAM_TYPE,

770: STREAM_TYPE.ID stream_type_id,
771: HEADER.KHR_ID,
772: LINES.KLE_ID KLE_ID
773: FROM
774: OKL_STRM_TYPE_B STREAM_TYPE,
775: OKL_SIF_RET_STRMS RETURN_STREAMS,
776: OKL_SIF_RETS RETURN_HEADER,
777: OKL_STREAM_INTERFACES HEADER,
778: OKL_SIF_LINES LINES

Line 819: OKL_STRM_TYPE_B STREAM_TYPE,

815: STREAM_TYPE.ID stream_type_id,
816: HEADER.KHR_ID,
817: LINES.KLE_ID KLE_ID
818: FROM
819: OKL_STRM_TYPE_B STREAM_TYPE,
820: OKL_SIF_RET_STRMS RETURN_STREAMS,
821: OKL_SIF_RETS RETURN_HEADER,
822: OKL_STREAM_INTERFACES HEADER,
823: OKL_SIF_LINES LINES,

Line 869: OKL_STRM_TYPE_B STREAM_TYPE,

865: HEADER.KHR_ID,
866:
867: LINES.KLE_ID KLE_ID
868: FROM
869: OKL_STRM_TYPE_B STREAM_TYPE,
870: OKL_SIF_RET_STRMS RETURN_STREAMS,
871: OKL_SIF_RETS RETURN_HEADER,
872: OKL_STREAM_INTERFACES HEADER,
873: OKL_SIF_LINES LINES,