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 1061: OKL_STRM_TYPE_B STY,

1057: CURSOR rbk_ctrct_csr ( p_contract_number VARCHAR2 ) IS
1058: SELECT distinct KHR.ID
1059: FROM OKC_K_HEADERS_B KHR,
1060: OKL_STREAMS STM,
1061: OKL_STRM_TYPE_B STY,
1062: OKL_STRM_ELEMENTS SEL
1063: WHERE KHR.contract_number = NVL(p_contract_number, contract_number)
1064: AND KHR.STS_CODE = 'BOOKED'
1065: AND KHR.ID = STM.KHR_ID

Line 1122: okl_strm_type_b sty,

1118: khr.sts_code sts_code
1119: FROM
1120: okl_strm_elements ste,
1121: okl_streams stm,
1122: okl_strm_type_b sty,
1123: okc_k_headers_b khr,
1124: okl_k_headers khl,
1125: okc_k_lines_b kle,
1126: okc_statuses_b khs,

Line 1772: okl_strm_type_b sty,

1768: PS.trx_number trx_number,
1769: PS.class,
1770: PS.TERMS_SEQUENCE_NUMBER
1771: FROM
1772: okl_strm_type_b sty,
1773: okc_k_headers_b khr,
1774: okl_k_headers khl,
1775: okc_k_lines_b kle,
1776: okc_statuses_b khs,