DBA Data[Home] [Help]

APPS.CN_POST_COLLECTION_TAE_PUB dependencies on CN_PERIODS_API

Line 159: cn_periods_api.set_dates(x_start_period_id, x_end_period_id,l_org_id,l_start_date, l_end_date);

155:
156: l_source_id := -1001;
157: l_trans_object_type_id := -1002;
158: l_org_id:=x_org_id;
159: cn_periods_api.set_dates(x_start_period_id, x_end_period_id,l_org_id,l_start_date, l_end_date);
160: l_where_clause :=' WHERE org_id=to_number('''||l_org_id||''') and txn_date between to_date('''||l_start_date|| ''',''dd-mon-yy'')' || ' and to_date('''|| l_end_date || ''',''dd-mon-yy'') ';
161:
162: BEGIN
163: select version_name