DBA Data[Home] [Help]

APPS.BEN_PRY_INS dependencies on DUAL

Line 334: Cursor C_Sel1 is select ben_prtt_rmt_aprvd_fr_pymt_s.nextval from sys.dual;

330: ) is
331: --
332: l_proc varchar2(72) := g_package||'pre_insert';
333: --
334: Cursor C_Sel1 is select ben_prtt_rmt_aprvd_fr_pymt_s.nextval from sys.dual;
335: Cursor C_num is
336: select nvl(max(apprvd_fr_pymt_num),0) + 1
337: from ben_prtt_rmt_aprvd_fr_pymt_f
338: where prtt_reimbmt_rqst_id = p_rec.prtt_reimbmt_rqst_id ;