APPS.OKL_COPY_CONTRACT_PVT dependencies on OKC_LINE_STYLES_B

Line 2572: OKC_LINE_STYLES_B cle_parent_lse,

2568: CURSOR abnd_tls_csr(p_copied_chr_id IN NUMBER) IS
2569: Select cle.id,
2570: cle.orig_system_id1
2571: from OKC_K_LINES_B cle_parent,
2572: OKC_LINE_STYLES_B cle_parent_lse,
2573: OKC_K_LINES_B cle
2574: WHERE cle_parent.id = cle.orig_system_id1
2575: AND cle_parent.lse_id = cle_parent_lse.id
2576: AND cle_parent.sts_code = 'ABANDONED'

Line 2585: OKC_LINE_STYLES_B cle_parent_lse,

2581: CURSOR abnd_sls_csr(p_copied_chr_id IN NUMBER) IS
2582: Select cle.id,
2583: cle.orig_system_id1
2584: from OKC_K_LINES_B cle_parent,
2585: OKC_LINE_STYLES_B cle_parent_lse,
2586: OKC_K_LINES_B cle
2587: WHERE cle_parent.id = cle.orig_system_id1
2588: AND cle_parent.lse_id = cle_parent_lse.id
2589: AND cle_parent.sts_code = 'ABANDONED'

Line 2681: OKC_LINE_STYLES_B cle_parent_lse,

2677: --Cursor for rollover parent top lines
2678: CURSOR roll_tls_csr(p_copied_chr_id IN NUMBER) IS
2679: Select cle.id, cle.orig_system_id1
2680: from OKC_K_LINES_B cle_parent,
2681: OKC_LINE_STYLES_B cle_parent_lse,
2682: OKC_K_LINES_B cle,
2683: okl_k_lines kle_parent
2684: WHERE cle_parent.id = kle_parent.id
2685: AND cle_parent.id = cle.orig_system_id1

Line 5413: TYPE l_lty_code_type IS TABLE OF okc_line_styles_b.lty_code%TYPE INDEX BY BINARY_INTEGER;

5409: TYPE l_sts_code_type IS TABLE OF okc_k_lines_b.sts_code%TYPE INDEX BY BINARY_INTEGER;
5410: TYPE l_trn_code_type IS TABLE OF okc_k_lines_b.trn_code%TYPE INDEX BY BINARY_INTEGER;
5411: TYPE l_lse_id_type IS TABLE OF okc_k_lines_b.lse_id%TYPE INDEX BY BINARY_INTEGER;
5412: --avsingh: Bug 5710213: start
5413: TYPE l_lty_code_type IS TABLE OF okc_line_styles_b.lty_code%TYPE INDEX BY BINARY_INTEGER;
5414: --avsingh: Bug 5710213: end
5415: TYPE l_exception_yn_type IS TABLE OF okc_k_lines_b.exception_yn%TYPE INDEX BY BINARY_INTEGER;
5416: TYPE l_object_version_number_type IS TABLE OF okc_k_lines_b.object_version_number%TYPE INDEX BY BINARY_INTEGER;
5417: TYPE l_created_by_type IS TABLE OF okc_k_lines_b.created_by%TYPE INDEX BY BINARY_INTEGER;

Line 9017: , okc_line_styles_b lsb

9013: okc_k_lines_b b,
9014: okl_k_lines c,
9015: fnd_languages d
9016: --avsingh: Bug 5710213: start
9017: , okc_line_styles_b lsb
9018: --avsingh: Bug 5710213: end
9019: WHERE a.id = b.id
9020: AND b.id = c.id
9021: AND a.id = c.id

Line 22270: okc_line_styles_b lse,

22266: /*
22267: SELECT cle.id top_line
22268: FROM okc_subclasses_b scs,
22269: okc_subclass_top_line stl,
22270: okc_line_styles_b lse,
22271: okc_k_lines_b cle
22272: WHERE cle.dnz_chr_id = p_dnz_chr_id
22273: AND cle.cle_id is null
22274: and cle.chr_id = cle.dnz_chr_id

Line 22283: FROM okc_line_styles_b lse,

22279: AND stl.scs_code = scs.code
22280: AND scs.cls_code = 'OKL';
22281: */
22282: SELECT cle.id top_line
22283: FROM okc_line_styles_b lse,
22284: okc_k_lines_b cle
22285: WHERE cle.dnz_chr_id = p_dnz_chr_id
22286: AND cle.cle_id is null
22287: and cle.chr_id = cle.dnz_chr_id

Line 22313: from OKC_LINE_STYLES_B lse,

22309: --Bug # 2412839 - Since copy insurance functionality is not supported at this
22310: -- time insurance lines will be deleted after they get copied by generic copy
22311: Cursor ins_top_line_csr (p_chr_id IN NUMBER) is
22312: select cle.id
22313: from OKC_LINE_STYLES_B lse,
22314: OKC_K_LINES_B cle
22315: where lse.lty_code = 'INSURANCE'
22316: and lse.id = cle.lse_id
22317: and lse.lse_type = 'TLS'

Line 22351: okc_line_styles_b lseb

22347: select txdb.id
22348: from okl_txd_assets_b txdb,
22349: okl_txl_assets_b txlb,
22350: okc_k_lines_b cleb,
22351: okc_line_styles_b lseb
22352: where txdb.tax_book = p_book_type_code
22353: and txdb.tal_id = txlb.id
22354: and txlb.kle_id = cleb.id
22355: and cleb.lse_id = lseb.id