DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on AP_TERMS

Line 4404: FROM ap_terms

4400: IF (p_invoice_rec.terms_id is not null) THEN
4401: --validate term_id
4402: SELECT term_id, start_date_active, end_date_active
4403: INTO l_term_id, l_start_date_active, l_end_date_active
4404: FROM ap_terms
4405: WHERE term_id = p_invoice_rec.terms_id;
4406: END IF;
4407:
4408: IF (p_invoice_rec.terms_name is not null) THEN

Line 4413: FROM ap_terms

4409: --validate terms name and retrieve term id
4410: SELECT term_id, start_date_active, end_date_active
4411: INTO l_term_id_per_name, l_start_date_active_per_name,
4412: l_end_date_active_per_name
4413: FROM ap_terms
4414: WHERE name = p_invoice_rec.terms_name;
4415: END IF;
4416:
4417: EXCEPTION

Line 4633: FROM ap_terms

4629: END IF;
4630:
4631: SELECT start_date_active, end_date_active
4632: INTO l_start_date_active, l_end_date_active
4633: FROM ap_terms
4634: WHERE term_id = l_term_id;
4635:
4636: END IF; -- l_terms_id is null
4637: END IF; -- nvl(l_current_invoice_status,'Y') = 'Y'

Line 4879: -- from ap_terms

4875: -- Bug 5448579. Calendar will be verified based on term_id
4876:
4877: -- select name
4878: -- into l_term_name
4879: -- from ap_terms
4880: -- where term_id = l_term_id;
4881:
4882: -- END IF;
4883: