APPS.OKS_COVERAGES_MIGRATION dependencies on OKS_COV_BILL_RATES_INT_ALL

Line 3836: FROM oks_cov_bill_rates_int_all obr ,

3832: okl.start_date,
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,

Line 3995: l_clev_tbl_in(i).Upg_Orig_System_Ref :='OKS_COV_BILL_RATES_INT_ALL'; --'Migrated_BILL_RATES';

3991: l_clev_tbl_in(i).attribute14 :=Attribute14_Tbl(i);
3992: l_clev_tbl_in(i).attribute15 :=Attribute15_Tbl(i);
3993: l_clev_tbl_in(i).attribute_Category :=ATTRIBUTE_CATEGORY_tbl(i);
3994: l_clev_tbl_in(i).dnz_chr_id := dnz_chr_id_tbl(i);
3995: l_clev_tbl_in(i).Upg_Orig_System_Ref :='OKS_COV_BILL_RATES_INT_ALL'; --'Migrated_BILL_RATES';
3996: l_clev_tbl_in(i).Upg_Orig_System_Ref_Id :=Coverage_Bill_Rate_ID_Tbl(i);
3997: l_clev_tbl_in(i).INVOICE_LINE_LEVEL_IND :=Null;
3998: l_clev_tbl_in(i).DPAS_RATING :=Null;
3999: l_clev_tbl_in(i).TEMPLATE_USED :=Null;

Line 4181: UPDATE oks_cov_bill_rates_int_all

4177:
4178: END IF;
4179: FORALL i in 1 .. COVERAGE_BILL_RATE_ID_tbl.COUNT
4180:
4181: UPDATE oks_cov_bill_rates_int_all
4182: SET INTERFACED_STATUS_FLAG = 'S',
4183: LAST_UPDATED_BY = -1,
4184: LAST_UPDATE_DATE = sysdate,
4185: LAST_UPDATE_LOGIN = -1

Line 4251: FROM oks_cov_bill_rates_int_all

4247:
4248: Cursor get_bill_rates (p_id in NUMBER)
4249: IS SELECT Interfaced_Status_flag,
4250: COVERAGE_BILL_RATE_ID
4251: FROM oks_cov_bill_rates_int_all
4252: WHERE COVERAGE_BILLING_TYPE_ID = p_id;
4253:
4254: BEGIN
4255: