APPS.OZF_CLAIM_DEF_RULE_PVT dependencies on AMS_CUSTOM_SETUPS_VL

Line 40: FROM ams_custom_setups_vl

36: from ozf_sys_parameters;
37:
38: CURSOR csr_seed_custom_setup(cv_custom_setup_id IN NUMBER) IS
39: SELECT custom_setup_id
40: FROM ams_custom_setups_vl
41: WHERE application_id = 682
42: AND enabled_flag = 'Y'
43: AND custom_setup_id = cv_custom_setup_id;
44:

Line 47: FROM ams_custom_setups_vl

43: AND custom_setup_id = cv_custom_setup_id;
44:
45: CURSOR csr_count_custom_setup(cv_claim_class IN VARCHAR2) IS
46: SELECT COUNT(custom_setup_id)
47: FROM ams_custom_setups_vl
48: WHERE application_id = 682
49: AND enabled_flag = 'Y'
50: AND object_type = 'CLAM'
51: AND activity_type_code = cv_claim_class;

Line 55: FROM ams_custom_setups_vl

51: AND activity_type_code = cv_claim_class;
52:
53: CURSOR csr_user_custom_setup(cv_claim_class IN VARCHAR2) IS
54: SELECT custom_setup_id
55: FROM ams_custom_setups_vl
56: WHERE application_id = 682
57: AND enabled_flag = 'Y'
58: AND object_type = 'CLAM'
59: AND activity_type_code = cv_claim_class;