DBA Data[Home] [Help]

APPS.OZF_FUNDS_PUB dependencies on AMS_CUSTOM_SETUPS_VL

Line 53: FROM ams_custom_setups_vl

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:

Line 60: FROM ams_custom_setups_vl

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;