APPS.OKL_CONTRACT_TOP_LINE_PVT dependencies on OKL_STRM_TMPT_FULL_UV

Line 96: FROM okl_strm_tmpt_full_uv

92: and K.ID = p_chr_id;
93:
94: Cursor l_strmtyp_id_csr IS
95: SELECT sty_id
96: FROM okl_strm_tmpt_full_uv
97: WHERE STY_PURPOSE = 'SERVICE_PAYMENT'
98: and exists (SELECT 1
99: FROM OKC_K_HEADERS_B chr,
100: OKL_K_HEADERS khr

Line 102: AND khr.pdt_id = okl_strm_tmpt_full_uv.PDT_ID

98: and exists (SELECT 1
99: FROM OKC_K_HEADERS_B chr,
100: OKL_K_HEADERS khr
101: WHERE chr.id = khr.id
102: AND khr.pdt_id = okl_strm_tmpt_full_uv.PDT_ID
103: AND trunc(chr.start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE) AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),chr.start_date+1)
104: AND chr.id = p_chr_id)
105: and sty_name = p_item_name;
106:

Line 103: AND trunc(chr.start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE) AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),chr.start_date+1)

99: FROM OKC_K_HEADERS_B chr,
100: OKL_K_HEADERS khr
101: WHERE chr.id = khr.id
102: AND khr.pdt_id = okl_strm_tmpt_full_uv.PDT_ID
103: AND trunc(chr.start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE) AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),chr.start_date+1)
104: AND chr.id = p_chr_id)
105: and sty_name = p_item_name;
106:
107: l_chr_id okc_k_headers_b.id%type := null;

Line 113: l_strmtyp_id okl_strm_tmpt_full_uv.sty_id%type := null;

109: l_s_cle_id okc_k_lines_b.id%type := null;
110: l_supp_id okx_vendors_v.id1%type := null;
111: x_okl_cle_id okc_k_lines_b.id%type := null;
112: l_rel_vers_id number := null;
113: l_strmtyp_id okl_strm_tmpt_full_uv.sty_id%type := null;
114: l_sts_code OKC_K_HEADERS_B.sts_code%type:= null;
115: l_ste_code OKC_STATUSES_B.STE_CODE%type:= null;
116:
117: l_api_name CONSTANT VARCHAR2(30) := 'create_contract_link_serv';