5061:
5062: CURSOR c IS
5063: SELECT calendar
5064: FROM ap_terms,
5065: ap_terms_lines
5066: WHERE ap_terms.term_id = ap_terms_lines.term_id
5067: AND ap_terms.term_id = p_terms_id
5068: AND ap_terms_lines.calendar is not null;
5069:
5062: CURSOR c IS
5063: SELECT calendar
5064: FROM ap_terms,
5065: ap_terms_lines
5066: WHERE ap_terms.term_id = ap_terms_lines.term_id
5067: AND ap_terms.term_id = p_terms_id
5068: AND ap_terms_lines.calendar is not null;
5069:
5070: l_calendar VARCHAR2(30);
5064: FROM ap_terms,
5065: ap_terms_lines
5066: WHERE ap_terms.term_id = ap_terms_lines.term_id
5067: AND ap_terms.term_id = p_terms_id
5068: AND ap_terms_lines.calendar is not null;
5069:
5070: l_calendar VARCHAR2(30);
5071: l_cal_exists VARCHAR2(1);
5072: l_debug_info VARCHAR2(100);