49: AND fund_number = p_fund_number;
50:
51: CURSOR c_cust_setup (p_fund_type IN VARCHAR2) IS
52: SELECT min(custom_setup_id)
53: FROM ams_custom_setups_vl
54: WHERE object_type = 'FUND'
55: AND application_id = 682
56: AND activity_type_code = p_fund_type;
57:
56: AND activity_type_code = p_fund_type;
57:
58: CURSOR c_cust_setup_exists (p_fund_type IN VARCHAR2, p_cust_setup_id IN NUMBER) IS
59: SELECT 1
60: FROM ams_custom_setups_vl
61: WHERE object_type = 'FUND'
62: AND application_id = 682
63: AND activity_type_code = p_fund_type
64: AND custom_setup_id = p_cust_setup_id;