APPS.OKS_UPGRADE_PRECHECK dependencies on OKC_STATUSES_V

Line 872: and exists (select b.code from okc_statuses_v b

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
873: where upper(old_stat.name) = upper(b.code));
874:
875: Cursor Cur_line_status IS
876: select old_stat.name old_status

Line 883: and exists (select b.code from okc_statuses_v b

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
884: where upper(old_stat.name) = upper(b.code));
885:
886: BEGIN
887: