APPS.OKL_TRANSFER_ASSUMPTION_PVT dependencies on OKC_K_LINES_B

Line 416: from okc_k_lines_b src_cle,

412: cursor c_src_chr (p_chr_id okc_k_headers_b.id%TYPE)
413: is
414: select src_cle.dnz_chr_id,
415: src_cle.id cle_id
416: from okc_k_lines_b src_cle,
417: okc_k_lines_b cle,
418: okc_line_styles_b lse
419: where src_cle.id = cle.ORIG_SYSTEM_ID1
420: and lse.id = cle.lse_id

Line 417: okc_k_lines_b cle,

413: is
414: select src_cle.dnz_chr_id,
415: src_cle.id cle_id
416: from okc_k_lines_b src_cle,
417: okc_k_lines_b cle,
418: okc_line_styles_b lse
419: where src_cle.id = cle.ORIG_SYSTEM_ID1
420: and lse.id = cle.lse_id
421: and lse.lty_code = 'FREE_FORM1'

Line 461: 5.2.1.1 get source contract's asset top line via okc_k_lines_b.ORIG_SYSTEM_ID1

457: -- Source contract T and A
458: -- May refer from multiple contracts if it's partial transfer
459: 5.2.1 get credit line ID for source contract if any (raise error if credit line not found?)
460: IF credit line found THEN
461: 5.2.1.1 get source contract's asset top line via okc_k_lines_b.ORIG_SYSTEM_ID1
462: 5.2.1.2 get total T and A for source contract asset via formula LINE_CAP_AMOUNT
463: 5.2.1.3 Update (add this amount as positive to OKL_K_HEADERS.TOT_CL_NET_TRANSFER_AMT) T and A for source contract's credit line
464: END IF;
465:

Line 488: -- get source contract's asset top line via okc_k_lines_b.ORIG_SYSTEM_ID1

484: -- get credit line ID for source contract if any (ignore if credit line not found?)
485: l_src_credit_id := OKL_CREDIT_PUB.get_creditline_by_chrid(r_src_chr.dnz_chr_id);
486:
487: -- IF credit line found THEN
488: -- get source contract's asset top line via okc_k_lines_b.ORIG_SYSTEM_ID1
489: -- get total T and A for source contract asset via formula LINE_CAP_AMOUNT
490: -- Update (add this amount as positive to OKL_K_HEADERS.TOT_CL_NET_TRANSFER_AMT) T and A for source contract's credit line
491: -- END IF;
492: if l_src_credit_id is not null then