DBA Data[Home] [Help]

APPS.AP_IMPORT_UTILITIES_PKG dependencies on AP_TERMS

Line 4926: FROM ap_terms,

4922: p_calling_sequence IN varchar2) IS
4923:
4924: CURSOR c IS
4925: SELECT calendar
4926: FROM ap_terms,
4927: ap_terms_lines
4928: WHERE ap_terms.term_id = ap_terms_lines.term_id
4929: AND ap_terms.term_id = p_terms_id
4930: AND ap_terms_lines.calendar is not null;

Line 4927: ap_terms_lines

4923:
4924: CURSOR c IS
4925: SELECT calendar
4926: FROM ap_terms,
4927: ap_terms_lines
4928: WHERE ap_terms.term_id = ap_terms_lines.term_id
4929: AND ap_terms.term_id = p_terms_id
4930: AND ap_terms_lines.calendar is not null;
4931:

Line 4928: WHERE ap_terms.term_id = ap_terms_lines.term_id

4924: CURSOR c IS
4925: SELECT calendar
4926: FROM ap_terms,
4927: ap_terms_lines
4928: WHERE ap_terms.term_id = ap_terms_lines.term_id
4929: AND ap_terms.term_id = p_terms_id
4930: AND ap_terms_lines.calendar is not null;
4931:
4932: l_calendar VARCHAR2(30);

Line 4929: AND ap_terms.term_id = p_terms_id

4925: SELECT calendar
4926: FROM ap_terms,
4927: ap_terms_lines
4928: WHERE ap_terms.term_id = ap_terms_lines.term_id
4929: AND ap_terms.term_id = p_terms_id
4930: AND ap_terms_lines.calendar is not null;
4931:
4932: l_calendar VARCHAR2(30);
4933: l_cal_exists VARCHAR2(1);

Line 4930: AND ap_terms_lines.calendar is not null;

4926: FROM ap_terms,
4927: ap_terms_lines
4928: WHERE ap_terms.term_id = ap_terms_lines.term_id
4929: AND ap_terms.term_id = p_terms_id
4930: AND ap_terms_lines.calendar is not null;
4931:
4932: l_calendar VARCHAR2(30);
4933: l_cal_exists VARCHAR2(1);
4934: l_debug_info VARCHAR2(100);