DBA Data[Home] [Help]

APPS.CN_CALC_POPULATE_PVT dependencies on CN_REPOSITORIES_ALL

Line 239: from cn_repositories_all

235: AND p_end_date >= sct.start_date_active;
236:
237: cursor rev_class_hierarchy_id is
238: select rev_class_hierarchy_id
239: from cn_repositories_all
240: where org_id = g_org_id;
241:
242: cursor salesreps is
243: select distinct

Line 404: cn_repositories_all r

400:
401: CURSOR l_dim_hierarchy_csr (l_processed_date DATE) IS
402: SELECT dim_hierarchy_id
403: FROM cn_dim_hierarchies_all dh,
404: cn_repositories_all r
405: WHERE r.org_id = g_org_id
406: AND r.rev_class_hierarchy_id = dh.header_dim_hierarchy_id
407: AND dh.org_id = g_org_id
408: AND l_processed_date BETWEEN dh.start_date AND dh.end_date;