DBA Data[Home] [Help]

APPS.ITG_SYNCSUPPLIERINBOUND_PVT dependencies on AP_TERMS

Line 294: FROM ap_terms

290:
291: BEGIN
292: SELECT term_id
293: INTO l_var
294: FROM ap_terms
295: WHERE upper(name) = upper(p_termid);
296: EXCEPTION
297: WHEN OTHERs THEN
298: ITG_MSG.missing_element_value('TERMID', p_termid);

Line 573: FROM ap_terms

569: l_syncind := UPPER(p_syncind);
570: IF p_termid IS NOT NULL THEN
571: SELECT term_id
572: INTO l_term_id
573: FROM ap_terms
574: WHERE upper(name) = upper(p_termid);
575: ELSE
576: l_term_id := null;
577: END IF;