APPS.AP_IMPORT_VALIDATION_PKG dependencies on AP_TERMS

Line 4137: FROM ap_terms

4133: IF (p_invoice_rec.terms_id is not null) THEN
4134: --validate term_id
4135: SELECT term_id, start_date_active, end_date_active
4136: INTO l_term_id, l_start_date_active, l_end_date_active
4137: FROM ap_terms
4138: WHERE term_id = p_invoice_rec.terms_id;
4139: END IF;
4140:
4141: IF (p_invoice_rec.terms_name is not null) THEN

Line 4146: FROM ap_terms

4142: --validate terms name and retrieve term id
4143: SELECT term_id, start_date_active, end_date_active
4144: INTO l_term_id_per_name, l_start_date_active_per_name,
4145: l_end_date_active_per_name
4146: FROM ap_terms
4147: WHERE name = p_invoice_rec.terms_name;
4148: END IF;
4149:
4150: EXCEPTION

Line 4366: FROM ap_terms

4362: END IF;
4363:
4364: SELECT start_date_active, end_date_active
4365: INTO l_start_date_active, l_end_date_active
4366: FROM ap_terms
4367: WHERE term_id = l_term_id;
4368:
4369: END IF; -- l_terms_id is null
4370: END IF; -- nvl(l_current_invoice_status,'Y') = 'Y'

Line 4593: -- from ap_terms

4589: -- Bug 5448579. Calendar will be verified based on term_id
4590:
4591: -- select name
4592: -- into l_term_name
4593: -- from ap_terms
4594: -- where term_id = l_term_id;
4595:
4596: -- END IF;
4597: