DBA Data[Home] [Help]

APPS.OZF_MASS_SETTLEMENT_PVT dependencies on AMS_CUSTOM_SETUPS_B

Line 2377: FROM ams_custom_setups_b

2373: SELECT NVL(attr_available_flag, 'N')
2374: FROM ams_custom_setup_attr
2375: WHERE object_attribute = 'APPR'
2376: AND custom_setup_id =( SELECT custom_setup_id
2377: FROM ams_custom_setups_b
2378: WHERE activity_type_code = 'GROUP'
2379: AND object_type = 'CLAM'
2380: AND enabled_flag = 'Y' );
2381:

Line 3078: FROM ams_custom_setups_b

3074: SELECT NVL(attr_available_flag, 'N')
3075: FROM ams_custom_setup_attr
3076: WHERE object_attribute = 'APPR'
3077: AND custom_setup_id = ( SELECT custom_setup_id
3078: FROM ams_custom_setups_b
3079: WHERE activity_type_code = 'GROUP'
3080: AND object_type = 'CLAM'
3081: AND enabled_flag = 'Y' );
3082: