APPS.OKS_COVERAGES_MIGRATION dependencies on OKS_COV_BILL_TYPES_INT_ALL

Line 3389: oks_cov_bill_types_int_all obt ,

3385: okl.start_date ,
3386: okl.end_date ,
3387: okl.currency_code
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,

Line 3774: UPDATE oks_cov_bill_types_int_all

3770: -- dbms_output.put_line('Before Commit');
3771:
3772: FORALL i in 1 .. COV_BP_BILLING_TYPE_ID_tbl.COUNT
3773:
3774: UPDATE oks_cov_bill_types_int_all
3775: SET INTERFACED_STATUS_FLAG = 'S',
3776: LAST_UPDATED_BY = -1,
3777: LAST_UPDATE_DATE = sysdate,
3778: LAST_UPDATE_LOGIN = -1

Line 3837: oks_cov_bill_types_int_all obt,

3833: okl.end_date,
3834: okl.dnz_chr_id,
3835: okl.currency_code
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,

Line 4245: FROM oks_cov_bill_types_int_all

4241: IS SELECT Interfaced_Status_flag,
4242: COV_BP_BILLING_TYPE_ID,
4243: Upto_amount,
4244: Percent_Cover
4245: FROM oks_cov_bill_types_int_all
4246: WHERE coverage_bus_process_id = p_id;
4247:
4248: Cursor get_bill_rates (p_id in NUMBER)
4249: IS SELECT Interfaced_Status_flag,