APPS.OKS_COVERAGES_MIGRATION dependencies on OKS_CON_HEADERS_INT_ALL

Line 43: OKS_CON_HEADERS_INT_ALL head

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
47: and head.interfaced_status_flag = 'S'

Line 899: oks_con_headers_int_all head

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
903: AND cov.INTERFACED_STATUS_FLAG = 'S'

Line 3394: oks_con_headers_int_all head

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
3398: AND okl.upg_Orig_System_Ref= g_bpline_ref --'Int_Buss_Process_Line'

Line 3842: oks_con_headers_int_all head

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
3846: AND okl.lse_id = 5

Line 4215: FROM OKS_CON_HEADERS_INT_ALL

4211: IS SELECT contract_number,
4212: contract_id,
4213: interfaced_status_flag,
4214: batch_number
4215: FROM OKS_CON_HEADERS_INT_ALL
4216: WHERE BATCH_NUMBER between p_from_id and p_to_id;
4217:
4218: Cursor get_con_lines(p_id IN NUMBER)
4219: IS SELECT Contract_Id,