DBA Data[Home] [Help]

APPS.CN_COMP_PLANS_PKG dependencies on CN_GLOBAL_VAR

Line 156: OPEN check_overlap_curs(cn_global_var.g_rev_class_hierarchy_id,

152: l_end_date := least(nvl(pes(q1).end_date, pes(q2).end_date),
153: nvl(pes(q2).end_date, pes(q1).end_date));
154:
155: if l_start_date <= nvl(l_end_date, l_start_date) then
156: OPEN check_overlap_curs(cn_global_var.g_rev_class_hierarchy_id,
157: l_start_date, l_end_date, pes(q1).quota_id, pes(q2).quota_id);
158: FETCH check_overlap_curs INTO x_rev_class_total, x_rev_class_total_unique;
159: CLOSE check_overlap_curs;
160: