APPS.OZF_MASS_SETTLEMENT_PVT dependencies on AMS_CUSTOM_SETUP_ATTR

Line 2380: FROM ams_custom_setup_attr

2376: WHERE claim_id = cv_claim_id;
2377: /*
2378: CURSOR csr_mass_setl_appr_req IS
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'

Line 2392: FROM ams_custom_setup_attr

2388:
2389: -- Added by amitamku for Bug 13897890
2390: CURSOR csr_mass_setl_appr_req IS
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

Line 3198: FROM ams_custom_setup_attr

3194: FROM ozf_sys_parameters;
3195: /*
3196: CURSOR csr_mass_setl_appr_req IS
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'

Line 3210: FROM ams_custom_setup_attr

3206: */
3207: -- Added by amitamku for Bug 13897890
3208: CURSOR csr_mass_setl_appr_req IS
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