APPS.OKS_UPGRADE_PRECHECK dependencies on CS_CP_SERVICES_ALL

Line 842: select 'Y' from cs_cp_services_all

838: l_return_msg Varchar2(2000):= NULL;
839: l_exist_yn Varchar2(1);
840:
841: cursor Upg_Check_cur is
842: select 'Y' from cs_cp_services_all
843: where rownum < 2;
844:
845: BEGIN
846:

Line 878: cs_cp_services_all ccs,

874:
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)

Line 907: FROM cs_cp_services_all cs,

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