DBA Data[Home] [Help]

APPS.AP_TERMS_CAL_EXISTS_PKG dependencies on AP_TERMS_LINES

Line 12: ap_terms_lines

8: p_calling_sequence IN varchar2) IS
9: CURSOR c IS
10: SELECT calendar
11: FROM ap_terms,
12: ap_terms_lines
13: WHERE ap_terms.term_id = ap_terms_lines.term_id
14: AND ap_terms.name = p_terms_name
15: AND ap_terms_lines.calendar is not null;
16:

Line 13: WHERE ap_terms.term_id = ap_terms_lines.term_id

9: CURSOR c IS
10: SELECT calendar
11: FROM ap_terms,
12: ap_terms_lines
13: WHERE ap_terms.term_id = ap_terms_lines.term_id
14: AND ap_terms.name = p_terms_name
15: AND ap_terms_lines.calendar is not null;
16:
17: l_calendar VARCHAR2(30);

Line 15: AND ap_terms_lines.calendar is not null;

11: FROM ap_terms,
12: ap_terms_lines
13: WHERE ap_terms.term_id = ap_terms_lines.term_id
14: AND ap_terms.name = p_terms_name
15: AND ap_terms_lines.calendar is not null;
16:
17: l_calendar VARCHAR2(30);
18: l_cal_exists VARCHAR2(1);
19: l_debug_info VARCHAR2(100);