APPS.OKL_COPY_CONTRACT_PVT dependencies on OKC_LINE_STYLES_B

Line 2535: OKC_LINE_STYLES_B cle_parent_lse,

2531: CURSOR abnd_tls_csr(p_copied_chr_id IN NUMBER) IS
2532: Select cle.id,
2533: cle.orig_system_id1
2534: from OKC_K_LINES_B cle_parent,
2535: OKC_LINE_STYLES_B cle_parent_lse,
2536: OKC_K_LINES_B cle
2537: WHERE cle_parent.id = cle.orig_system_id1
2538: AND cle_parent.lse_id = cle_parent_lse.id
2539: AND cle_parent.sts_code = 'ABANDONED'

Line 2548: OKC_LINE_STYLES_B cle_parent_lse,

2544: CURSOR abnd_sls_csr(p_copied_chr_id IN NUMBER) IS
2545: Select cle.id,
2546: cle.orig_system_id1
2547: from OKC_K_LINES_B cle_parent,
2548: OKC_LINE_STYLES_B cle_parent_lse,
2549: OKC_K_LINES_B cle
2550: WHERE cle_parent.id = cle.orig_system_id1
2551: AND cle_parent.lse_id = cle_parent_lse.id
2552: AND cle_parent.sts_code = 'ABANDONED'

Line 2644: OKC_LINE_STYLES_B cle_parent_lse,

2640: --Cursor for rollover parent top lines
2641: CURSOR roll_tls_csr(p_copied_chr_id IN NUMBER) IS
2642: Select cle.id, cle.orig_system_id1
2643: from OKC_K_LINES_B cle_parent,
2644: OKC_LINE_STYLES_B cle_parent_lse,
2645: OKC_K_LINES_B cle,
2646: okl_k_lines kle_parent
2647: WHERE cle_parent.id = kle_parent.id
2648: AND cle_parent.id = cle.orig_system_id1

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

5333: TYPE l_sts_code_type IS TABLE OF okc_k_lines_b.sts_code%TYPE INDEX BY BINARY_INTEGER;
5334: TYPE l_trn_code_type IS TABLE OF okc_k_lines_b.trn_code%TYPE INDEX BY BINARY_INTEGER;
5335: TYPE l_lse_id_type IS TABLE OF okc_k_lines_b.lse_id%TYPE INDEX BY BINARY_INTEGER;
5336: --avsingh: Bug 5710213: start
5337: TYPE l_lty_code_type IS TABLE OF okc_line_styles_b.lty_code%TYPE INDEX BY BINARY_INTEGER;
5338: --avsingh: Bug 5710213: end
5339: TYPE l_exception_yn_type IS TABLE OF okc_k_lines_b.exception_yn%TYPE INDEX BY BINARY_INTEGER;
5340: TYPE l_object_version_number_type IS TABLE OF okc_k_lines_b.object_version_number%TYPE INDEX BY BINARY_INTEGER;
5341: TYPE l_created_by_type IS TABLE OF okc_k_lines_b.created_by%TYPE INDEX BY BINARY_INTEGER;

Line 8930: , okc_line_styles_b lsb

8926: okc_k_lines_b b,
8927: okl_k_lines c,
8928: fnd_languages d
8929: --avsingh: Bug 5710213: start
8930: , okc_line_styles_b lsb
8931: --avsingh: Bug 5710213: end
8932: WHERE a.id = b.id
8933: AND b.id = c.id
8934: AND a.id = c.id

Line 22092: okc_line_styles_b lse,

22088: /*
22089: SELECT cle.id top_line
22090: FROM okc_subclasses_b scs,
22091: okc_subclass_top_line stl,
22092: okc_line_styles_b lse,
22093: okc_k_lines_b cle
22094: WHERE cle.dnz_chr_id = p_dnz_chr_id
22095: AND cle.cle_id is null
22096: and cle.chr_id = cle.dnz_chr_id

Line 22105: FROM okc_line_styles_b lse,

22101: AND stl.scs_code = scs.code
22102: AND scs.cls_code = 'OKL';
22103: */
22104: SELECT cle.id top_line
22105: FROM okc_line_styles_b lse,
22106: okc_k_lines_b cle
22107: WHERE cle.dnz_chr_id = p_dnz_chr_id
22108: AND cle.cle_id is null
22109: and cle.chr_id = cle.dnz_chr_id

Line 22135: from OKC_LINE_STYLES_B lse,

22131: --Bug # 2412839 - Since copy insurance functionality is not supported at this
22132: -- time insurance lines will be deleted after they get copied by generic copy
22133: Cursor ins_top_line_csr (p_chr_id IN NUMBER) is
22134: select cle.id
22135: from OKC_LINE_STYLES_B lse,
22136: OKC_K_LINES_B cle
22137: where lse.lty_code = 'INSURANCE'
22138: and lse.id = cle.lse_id
22139: and lse.lse_type = 'TLS'

Line 22173: okc_line_styles_b lseb

22169: select txdb.id
22170: from okl_txd_assets_b txdb,
22171: okl_txl_assets_b txlb,
22172: okc_k_lines_b cleb,
22173: okc_line_styles_b lseb
22174: where txdb.tax_book = p_book_type_code
22175: and txdb.tal_id = txlb.id
22176: and txlb.kle_id = cleb.id
22177: and cleb.lse_id = lseb.id