DBA Data[Home] [Help]

APPS.OKL_LOSS_PROV_PVT dependencies on OKL_POOL_CONTENTS

Line 1062: ,streams_to_date OKL_POOL_CONTENTS_V.streams_to_date%TYPE);

1058: TYPE pool_contents_rec_type is RECORD(
1059: lease_contract_id OKL_K_HEADERS_FULL_V.ID%TYPE
1060: ,sty_id OKL_STRM_TYPE_V.ID%TYPE
1061: ,sty_subclass OKL_STRM_TYPE_V.STREAM_TYPE_SUBCLASS%TYPE
1062: ,streams_to_date OKL_POOL_CONTENTS_V.streams_to_date%TYPE);
1063:
1064: TYPE pdt_contracts_tbl_type IS TABLE OF pdt_contracts_rec_type INDEX BY BINARY_INTEGER;
1065: TYPE pool_contents_tbl_type IS TABLE OF pool_contents_rec_type INDEX BY BINARY_INTEGER;
1066:

Line 1220: OKL_POOL_CONTENTS poc,

1216: sty.id sty_id,
1217: sty.stream_type_subclass sty_subclass,
1218: poc.streams_to_date streams_to_date
1219: FROM OKL_POOLS pol,
1220: OKL_POOL_CONTENTS poc,
1221: OKL_STRM_TYPE_B sty,
1222: OKC_K_HEADERS_B chr,
1223: OKL_K_HEADERS khr
1224: WHERE pol.khr_id = p_agr_id