1089: l_cas_id NUMBER;
1090: p_delinquency_id NUMBER;
1091: p_bankruptcy_id NUMBER;
1092:
1093: CaseIdTab IEX_UTILITIES.t_numbers;
1094: DelIdTab IEX_UTILITIES.t_numbers;
1095:
1096: CURSOR C_CASE(p_party_id NUMBER) IS
1097: SELECT cas_id
1090: p_delinquency_id NUMBER;
1091: p_bankruptcy_id NUMBER;
1092:
1093: CaseIdTab IEX_UTILITIES.t_numbers;
1094: DelIdTab IEX_UTILITIES.t_numbers;
1095:
1096: CURSOR C_CASE(p_party_id NUMBER) IS
1097: SELECT cas_id
1098: FROM iex_cases_all_b
1275: l_cas_id NUMBER;
1276: p_delinquency_id NUMBER;
1277: p_bankruptcy_id NUMBER;
1278:
1279: CaseIdTab IEX_UTILITIES.t_numbers;
1280: DelIdTab IEX_UTILITIES.t_numbers;
1281:
1282: CURSOR C_CASE(p_party_id NUMBER) IS
1283: SELECT cas_id
1276: p_delinquency_id NUMBER;
1277: p_bankruptcy_id NUMBER;
1278:
1279: CaseIdTab IEX_UTILITIES.t_numbers;
1280: DelIdTab IEX_UTILITIES.t_numbers;
1281:
1282: CURSOR C_CASE(p_party_id NUMBER) IS
1283: SELECT cas_id
1284: FROM iex_cases_all_b