APPS.OKS_UPGRADE_PRECHECK dependencies on OKC_K_LINES_B

Line 904: UPDATE OKC_K_LINES_B

900:
901: FOR status_rec IN cur_line_status
902: LOOP
903:
904: UPDATE OKC_K_LINES_B
905: SET STS_CODE = UPPER(status_rec.old_status)
906: WHERE id in (select cs.cp_service_id
907: FROM cs_cp_services_all cs,
908: cs_contract_statuses stat

Line 923: OKC_K_LINES_B cle

919:
920: CURSOR Cur_tz IS
921: SELECT distinct dnz_chr_id
922: FROM CS_COVERAGE_TXN_GROUPS ctxg,
923: OKC_K_LINES_B cle
924: WHERE cle.upg_Orig_System_Ref='CS_COVERAGE_TXN_GROUPS'
925: AND cle.upg_Orig_System_Ref_Id = ctxg.Coverage_txn_Group_id
926: AND ctxg.Time_Zone_Id IS NULL;
927:

Line 945: OKC_K_LINES_B cle

941: WHERE timezone_id = nvl(FND_PROFILE.value('CS_UPG_CONTRACTS_TIMEZONE'),47)
942: AND dnz_chr_id IN --= tz_rec.chr_id
943: ( SELECT distinct dnz_chr_id
944: FROM CS_COVERAGE_TXN_GROUPS ctxg,
945: OKC_K_LINES_B cle
946: WHERE cle.upg_Orig_System_Ref='CS_COVERAGE_TXN_GROUPS'
947: AND cle.upg_Orig_System_Ref_Id = ctxg.Coverage_txn_Group_id
948: AND ctxg.Time_Zone_Id IS NULL);
949:

Line 973: Where index_name like 'OKC_K_LINES_B_UPG'

969:
970: cursor get_cov_sch_index(c_owner in varchar2) is
971: Select index_name
972: From all_indexes
973: Where index_name like 'OKC_K_LINES_B_UPG'
974: and owner = c_owner;
975:
976: Cursor get_mtl_index(c_owner in varchar2) is
977: Select index_name

Line 1014: l_string := 'create index okc_k_lines_b_upg on okc_k_lines_b(upg_orig_system_ref,upg_orig_system_ref_id)';

1010: END LOOP;
1011:
1012: if l_index IS NULL then
1013:
1014: l_string := 'create index okc_k_lines_b_upg on okc_k_lines_b(upg_orig_system_ref,upg_orig_system_ref_id)';
1015:
1016: BEGIN
1017: l_var := dbms_sql.open_cursor;
1018: dbms_sql.parse(l_var ,l_string,dbms_sql.native);