APPS.OKS_UPGRADE_PRECHECK dependencies on CS_CONTRACT_STATUSES

Line 868: cs_contract_statuses old_stat

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)
872: and exists (select b.code from okc_statuses_v b

Line 879: cs_contract_statuses old_stat

875: Cursor Cur_line_status IS
876: select old_stat.name old_status
877: from okc_k_lines_v kl ,
878: cs_cp_services_all ccs,
879: cs_contract_statuses old_stat
880: where ccs.contract_line_status_id = old_stat.contract_status_id
881: and ccs.cp_service_id = kl.id
882: and upper(kl.sts_code) <> upper(old_stat.name)
883: and exists (select b.code from okc_statuses_v b

Line 895: cs_contract_statuses stat

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:
899: END LOOP;

Line 908: cs_contract_statuses stat

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
909: WHERE cs.contract_line_status_id = stat.contract_status_id
910: AND stat.name = status_rec.old_status);
911:
912: END LOOP;