DBA Data[Home] [Help]

APPS.OZF_MASS_SETTLEMENT_PVT dependencies on OZF_CLAIM_DEF_RULES_ALL

Line 2396: ozf_claim_def_rules_ALL ocd

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'
2400: AND acs.custom_setup_id = ocd.custom_setup_id

Line 3214: ozf_claim_def_rules_ALL ocd

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'
3218: AND acs.custom_setup_id = ocd.custom_setup_id