DBA Data[Home] [Help]

APPS.CN_COMP_PLANS_PKG dependencies on CN_GLOBAL_VAR

Line 157: OPEN check_overlap_curs(cn_global_var.g_rev_class_hierarchy_id,

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