APPS.OKS_UPGRADE_PRECHECK dependencies on CS_CONTRACTS_ALL

Line 867: cs_contracts_all csc,

863:
864: Cursor Cur_hdr_status IS
865: select old_stat.name old_status
866: from okc_k_headers_v kh ,
867: cs_contracts_all csc,
868: cs_contract_statuses old_stat
869: where csc.contract_status_id = old_stat.contract_status_id
870: and csc.contract_id = kh.id
871: and upper(kh.sts_code) <> upper(old_stat.name)

Line 894: FROM cs_contracts_all cc,

890:
891: UPDATE OKC_K_HEADERS_B
892: SET STS_CODE = UPPER(status_rec.old_status)
893: WHERE id in (select cc.contract_id
894: FROM cs_contracts_all cc,
895: cs_contract_statuses stat
896: WHERE cc.contract_status_id = stat.contract_status_id
897: AND stat.name = status_rec.old_status);
898: