APPS.OKS_COVERAGES_MIGRATION dependencies on OKS_CON_LINES_INT_ALL

Line 42: OKS_CON_LINES_INT_ALL lines,

38: cov.ATTRIBUTE13,
39: cov.ATTRIBUTE14,
40: cov.ATTRIBUTE15
41: from oks_coverages_int_all cov,
42: OKS_CON_LINES_INT_ALL lines,
43: OKS_CON_HEADERS_INT_ALL head
44: where cov.coverage_id <> 0
45: and cov.interfaced_status_flag is null
46: and head.batch_number between p_FromId and p_ToID

Line 69: FROM OKC_K_LINES_B cle1,OKS_CON_LINES_INT_ALL ocl

65: cle1.CREATION_DATE CREATION_DATE,
66: cle1.LAST_UPDATED_BY LAST_UPDATED_BY,
67: cle1.LAST_UPDATE_DATE LAST_UPDATE_DATE,
68: cle1.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
69: FROM OKC_K_LINES_B cle1,OKS_CON_LINES_INT_ALL ocl
70: WHERE cle1.Lse_Id = 1
71: AND cle1.UPG_ORIG_SYSTEM_REF_ID = ocl.contract_line_id
72: AND cle1.dnz_chr_Id <> -1
73: AND cle1.UPG_ORIG_SYSTEM_REF = g_line_ref

Line 80: from oks_con_lines_int_all

76: get_okc_lines_rec get_okc_lines_cur%rowtype;
77:
78: CURSOR get_cov_id_cur is
79: select nvl(coverage_id,0) id,nvl(coverage_template_id,0) tid
80: from oks_con_lines_int_all
81: where coverage_id <> 0;
82:
83: CURSOR get_mtl_cov_id_cur is
84: select distinct coverage_schedule_id id

Line 898: oks_con_lines_int_all lines,

894: okl.currency_code
895: FROM oks_cov_txn_groups_int_all obp,
896: okc_k_lines_b okl,
897: oks_coverages_int_all cov,
898: oks_con_lines_int_all lines,
899: oks_con_headers_int_all head
900: WHERE okl.upg_Orig_System_Ref= g_covline_ref
901: AND okl.upg_Orig_System_Ref_Id = obp.Coverage_Id
902: AND obp.coverage_id = cov.coverage_id

Line 3393: oks_con_lines_int_all lines,

3389: oks_cov_bill_types_int_all obt ,
3390: oks_cov_txn_groups_int_all obp,
3391: okc_k_lines_b okl,
3392: oks_coverages_int_all cov,
3393: oks_con_lines_int_all lines,
3394: oks_con_headers_int_all head
3395:
3396: WHERE
3397: obt.COVERAGE_BUS_PROCESS_ID = obp.COVERAGE_BUS_PROCESS_ID

Line 3841: oks_con_lines_int_all lines,

3837: oks_cov_bill_types_int_all obt,
3838: okc_k_lines_b okl,
3839: oks_cov_txn_groups_int_all obp,
3840: oks_coverages_int_all cov,
3841: oks_con_lines_int_all lines,
3842: oks_con_headers_int_all head
3843: WHERE obr.COVERAGE_BILLING_TYPE_ID = obt.COV_BP_BILLING_TYPE_ID
3844: AND okl.upg_Orig_System_Ref= g_btline_ref
3845: AND okl.upg_Orig_System_Ref_Id = obt.COV_BP_BILLING_TYPE_ID

Line 4223: FROM OKS_CON_LINES_INT_ALL lines

4219: IS SELECT Contract_Id,
4220: Contract_line_id,
4221: Coverage_Id,
4222: Interfaced_status_flag
4223: FROM OKS_CON_LINES_INT_ALL lines
4224: WHERE lines.contract_id = p_id;
4225:
4226: Cursor get_coverages(p_id IN NUMBER)
4227: IS SELECT Coverage_id,