DBA Data[Home] [Help]

APPS.OZF_FUND_RECONCILE_PVT dependencies on JTF_PERZ_QUERY_PARAM

Line 2070: FROM JTF_PERZ_QUERY_PARAM WHERE QUERY_ID = l_query_id AND PARAMETER_TYPE = 'condition';

2066: SELECT DECODE(PARAMETER_NAME,'parentId', 'parent_fund_id','statusId','status_code','num','fund_number','typeId',
2067: 'fund_type','name','short_name','startDate','start_date_active','endDate','end_date_active','currency','currency_code_tc',
2068: 'ownerId','owner','startPeriodName','start_period_name','endPeriodName','end_period_name','categoryId','category_id',
2069: 'baseQueryType','baseQueryType','1'), DECODE(PARAMETER_CONDITION,'CONS','LIKE',PARAMETER_CONDITION),PARAMETER_VALUE
2070: FROM JTF_PERZ_QUERY_PARAM WHERE QUERY_ID = l_query_id AND PARAMETER_TYPE = 'condition';
2071: BEGIN
2072: IF G_DEBUG THEN
2073: ozf_utility_pvt.write_conc_log(l_full_name || ': start');
2074: END IF;