DBA Data[Home] [Help]

APPS.OZF_FORECAST_UTIL_PVT dependencies on OZF_DENORM_QUERIES

Line 1203: FROM ozf_denorm_queries

1199: CURSOR check_for_site(l_context VARCHAR2, l_attribute VARCHAR2) IS
1200: SELECT DECODE(instr(upper(condition_id_column),'SITE_USE_ID'),
1201: 0,DECODE(instr(upper(condition_id_column),'PARTY_SITE_ID'),0,'N','P'),
1202: 'C')
1203: FROM ozf_denorm_queries
1204: WHERE query_for='ELIG'
1205: AND condition_id_column IS NOT NULL
1206: AND context = l_context
1207: AND attribute = l_attribute;