[Home] [Help]
820: DelIdTab IEX_UTILITIES.t_numbers;
821:
822: CURSOR C_CASE(p_party_id NUMBER) IS
823: SELECT cas_id
824: FROM iex_cases_all_b
825: WHERE party_id = p_party_id;
826:
827: CURSOR C_DELINQ(p_case_id NUMBER) IS
828: SELECT delinquency_id
1006: DelIdTab IEX_UTILITIES.t_numbers;
1007:
1008: CURSOR C_CASE(p_party_id NUMBER) IS
1009: SELECT cas_id
1010: FROM iex_cases_all_b
1011: WHERE party_id = p_party_id;
1012:
1013: CURSOR C_DELINQ(p_case_id NUMBER) IS
1014: SELECT delinquency_id