DBA Data[Home] [Help]

APPS.OKS_COVERAGES_MIGRATION dependencies on OKC_STATUSES_V

Line 1055: FROM OKC_STATUSES_V new, CS_CONTRACT_STATUSES old

1051: PROCEDURE Fetch_K_Status IS
1052: CURSOR K_Status_Cur IS
1053: SELECT old.contract_status_id k_id, upper(old.name) old_stat,
1054: decode(new.code, NULL,'ENTERED',upper(old.name)) new_stat
1055: FROM OKC_STATUSES_V new, CS_CONTRACT_STATUSES old
1056: WHERE upper(new.code(+)) = upper(old.name);
1057: BEGIN
1058: FOR K_Status_Rec IN K_Status_Cur
1059: LOOP