APPS.OKS_COVERAGES_MIGRATION dependencies on OKS_COVERAGES_INT_ALL

Line 41: from oks_coverages_int_all cov,

37: cov.ATTRIBUTE12,
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

Line 793: UPDATE oks_coverages_int_all

789: l_rgpv_tbl_in.delete;
790: -- dbms_output.put_line('After 0 Delete');
791:
792: end loop;
793: UPDATE oks_coverages_int_all
794: SET INTERFACED_STATUS_FLAG = 'S',
795: LAST_UPDATED_BY = -1,
796: LAST_UPDATE_DATE = sysdate,
797: LAST_UPDATE_LOGIN = -1

Line 897: oks_coverages_int_all cov,

893: okl.sts_code,
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

Line 3392: oks_coverages_int_all cov,

3388: FROM
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

Line 3840: oks_coverages_int_all cov,

3836: FROM oks_cov_bill_rates_int_all obr ,
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

Line 4230: FROM OKS_COVERAGES_INT_ALL cov

4226: Cursor get_coverages(p_id IN NUMBER)
4227: IS SELECT Coverage_id,
4228: NAME,
4229: Interfaced_status_flag
4230: FROM OKS_COVERAGES_INT_ALL cov
4231: WHERE cov.coverage_id = p_id;
4232:
4233: Cursor get_Buss_Process (p_id in NUMBER)
4234: IS SELECT Coverage_Bus_process_id,