APPS.AR_CM_APPLICATION_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 304

		SELECT term_id
		INTO l_term_id
		FROM ap_terms_bat_pay_terms_v
		WHERE term_id = p_terms_id;

Line: 801

        SELECT applied_payment_schedule_id, application_ref_id
	INTO   l_applied_ps_id, l_application_ref_id
	FROM   ar_receivable_applications
  	WHERE  receivable_application_id = l_receivable_application_id;