DBA Data[Home] [Help]

APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKC_LINE_STYLES_B

Line 3419: ,okc_line_styles_b style

3415: ,okl.origination_income
3416: FROM okc_k_lines_b okc
3417: ,okl_k_lines okl
3418: ,okc_k_items item
3419: ,okc_line_styles_b style
3420: --,okc_k_party_roles_b partyb -- change added for Rebook Change Control Enhancement
3421: WHERE okc.id = okl.id
3422: AND okc.id = item.cle_id
3423: AND okc.dnz_chr_id = item.dnz_chr_id

Line 3478: okc_line_styles_b style

3474: okl.origination_income
3475: FROM okc_k_lines_b okc,
3476: okl_k_lines okl,
3477: okc_k_items item,
3478: okc_line_styles_b style
3479: --okc_k_party_roles_b partyb
3480: WHERE okc.id = okl.id
3481: AND okc.id = item.cle_id
3482: AND okc.dnz_chr_id = item.dnz_chr_id

Line 3539: okc_line_styles_b style,

3535: okl.capital_amount, okl.amount,
3536: item.id item_id, item.object1_id1, item.object1_id2, item.jtot_object1_code
3537: FROM okc_k_lines_b okc_cov_ast,
3538: okl_k_lines okl,
3539: okc_line_styles_b style,
3540: okc_k_items item,
3541: okc_k_lines_v okc_fin
3542: WHERE okc_cov_ast.cle_id = p_top_line_id
3543: AND okc_cov_ast.dnz_chr_id = p_chr_id

Line 3563: okc_line_styles_b style,

3559: okl.capital_amount,
3560: item.id item_id, item.object1_id1, item.object1_id2, item.jtot_object1_code
3561: FROM okc_k_lines_v okc,
3562: okl_k_lines okl,
3563: okc_line_styles_b style,
3564: okc_k_items item
3565: WHERE okc.id = p_sub_line_id
3566: AND okc.dnz_chr_id = p_chr_id
3567: AND okc.id = okl.id

Line 4322: okc_line_styles_b style

4318:
4319: CURSOR rbk_new_service_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4320: SELECT line.id
4321: FROM okc_k_lines_b line,
4322: okc_line_styles_b style
4323: WHERE style.lty_code = 'SOLD_SERVICE'
4324: AND line.dnz_chr_id = p_chr_id
4325: AND line.chr_id = p_chr_id
4326: AND line.lse_id = style.id

Line 4381: ,okc_line_styles_b style

4377: ,okl.attribute15
4378: FROM okc_k_lines_v okc
4379: ,okl_k_lines okl
4380: ,okc_k_items item
4381: ,okc_line_styles_b style
4382: WHERE okc.id = okl.id
4383: AND okc.id = item.cle_id
4384: AND okc.dnz_chr_id = item.dnz_chr_id
4385: AND okl.id = item.cle_id

Line 4434: okc_line_styles_b style

4430: okl.attribute15
4431: FROM okc_k_lines_v okc,
4432: okl_k_lines okl,
4433: okc_k_items item,
4434: okc_line_styles_b style
4435: WHERE okc.id = okl.id
4436: AND okc.id = item.cle_id
4437: AND okc.dnz_chr_id = item.dnz_chr_id
4438: AND okl.id = item.cle_id

Line 4455: okc_line_styles_b style,

4451: okl.capital_amount, okl.amount,
4452: item.id item_id, item.object1_id1, item.object1_id2, item.jtot_object1_code
4453: FROM okc_k_lines_b okc_cov_ast,
4454: okl_k_lines okl,
4455: okc_line_styles_b style,
4456: okc_k_items item,
4457: okc_k_lines_v okc_fin
4458: WHERE okc_cov_ast.cle_id = p_top_line_id
4459: AND okc_cov_ast.dnz_chr_id = p_chr_id

Line 4478: okc_line_styles_b style,

4474: okl.capital_amount,
4475: item.id item_id, item.object1_id1, item.object1_id2, item.jtot_object1_code
4476: FROM okc_k_lines_v okc,
4477: okl_k_lines okl,
4478: okc_line_styles_b style,
4479: okc_k_items item
4480: WHERE okc.id = p_sub_line_id
4481: AND okc.dnz_chr_id = p_chr_id
4482: AND okc.id = okl.id