APPS.OZF_MASS_SETTLEMENT_PVT dependencies on AMS_CUSTOM_SETUPS_B

Line 2383: FROM ams_custom_setups_b

2379: SELECT NVL(attr_available_flag, 'N')
2380: FROM ams_custom_setup_attr
2381: WHERE object_attribute = 'APPR'
2382: AND custom_setup_id =( SELECT custom_setup_id
2383: FROM ams_custom_setups_b
2384: WHERE activity_type_code = 'GROUP'
2385: AND object_type = 'CLAM'
2386: AND enabled_flag = 'Y' );
2387: */

Line 2395: FROM ams_custom_setups_b acs,

2391: SELECT NVL(attr_available_flag, 'N')
2392: FROM ams_custom_setup_attr
2393: WHERE object_attribute = 'APPR'
2394: AND custom_setup_id = ( SELECT acs.custom_setup_id
2395: FROM ams_custom_setups_b acs,
2396: ozf_claim_def_rules_ALL ocd
2397: WHERE acs.activity_type_code = 'GROUP'
2398: AND acs.object_type = 'CLAM'
2399: AND acs.enabled_flag = 'Y'

Line 3201: FROM ams_custom_setups_b

3197: SELECT NVL(attr_available_flag, 'N')
3198: FROM ams_custom_setup_attr
3199: WHERE object_attribute = 'APPR'
3200: AND custom_setup_id = ( SELECT custom_setup_id
3201: FROM ams_custom_setups_b
3202: WHERE activity_type_code = 'GROUP'
3203: AND object_type = 'CLAM'
3204: AND enabled_flag = 'Y' );
3205:

Line 3213: FROM ams_custom_setups_b acs,

3209: SELECT NVL(attr_available_flag, 'N')
3210: FROM ams_custom_setup_attr
3211: WHERE object_attribute = 'APPR'
3212: AND custom_setup_id = ( SELECT acs.custom_setup_id
3213: FROM ams_custom_setups_b acs,
3214: ozf_claim_def_rules_ALL ocd
3215: WHERE acs.activity_type_code = 'GROUP'
3216: AND acs.object_type = 'CLAM'
3217: AND acs.enabled_flag = 'Y'