APPS.OKL_REBOOK_CM_PVT dependencies on OKL_STRM_TYPE_B

Line 84: OKL_STRM_TYPE_B STY,

80: CURSOR rbk_ctrct_csr ( p_contract_number VARCHAR2 ) IS
81: SELECT distinct KHR.ID
82: FROM OKC_K_HEADERS_B KHR,
83: OKL_STREAMS STM,
84: OKL_STRM_TYPE_B STY,
85: OKL_STRM_ELEMENTS SEL
86: WHERE KHR.contract_number = NVL(p_contract_number, contract_number)
87: AND KHR.STS_CODE = 'BOOKED'
88: AND KHR.ID = STM.KHR_ID

Line 143: okl_strm_type_b sty,

139: khr.sts_code sts_code
140: FROM
141: okl_strm_elements ste,
142: okl_streams stm,
143: okl_strm_type_b sty,
144: okc_k_headers_b khr,
145: okl_k_headers khl,
146: okc_k_lines_b kle,
147: okc_statuses_b khs,

Line 205: okl_strm_type_b sty,

201: PS.trx_number trx_number,
202: PS.class,
203: PS.TERMS_SEQUENCE_NUMBER
204: FROM
205: okl_strm_type_b sty,
206: okc_k_headers_b khr,
207: okl_k_headers khl,
208: okc_k_lines_b kle,
209: okc_statuses_b khs,

Line 1052: OKL_STRM_TYPE_B STY,

1048: CURSOR rbk_ctrct_csr ( p_contract_number VARCHAR2 ) IS
1049: SELECT distinct KHR.ID
1050: FROM OKC_K_HEADERS_B KHR,
1051: OKL_STREAMS STM,
1052: OKL_STRM_TYPE_B STY,
1053: OKL_STRM_ELEMENTS SEL
1054: WHERE KHR.contract_number = NVL(p_contract_number, contract_number)
1055: AND KHR.STS_CODE = 'BOOKED'
1056: AND KHR.ID = STM.KHR_ID

Line 1113: okl_strm_type_b sty,

1109: khr.sts_code sts_code
1110: FROM
1111: okl_strm_elements ste,
1112: okl_streams stm,
1113: okl_strm_type_b sty,
1114: okc_k_headers_b khr,
1115: okl_k_headers khl,
1116: okc_k_lines_b kle,
1117: okc_statuses_b khs,

Line 1757: okl_strm_type_b sty,

1753: PS.trx_number trx_number,
1754: PS.class,
1755: PS.TERMS_SEQUENCE_NUMBER
1756: FROM
1757: okl_strm_type_b sty,
1758: okc_k_headers_b khr,
1759: okl_k_headers khl,
1760: okc_k_lines_b kle,
1761: okc_statuses_b khs,