DBA Data[Home] [Help]

APPS.OZF_MASS_SETTLEMENT_PVT dependencies on AMS_CUSTOM_SETUP_ATTR

Line 2374: FROM ams_custom_setup_attr

2370: WHERE claim_id = cv_claim_id;
2371:
2372: CURSOR csr_mass_setl_appr_req IS
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'

Line 3075: FROM ams_custom_setup_attr

3071: FROM ozf_sys_parameters;
3072:
3073: CURSOR csr_mass_setl_appr_req IS
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'