1739: l_mpayeeid iby_payee.mpayeeid%TYPE;
1740: l_trxn_exists VARCHAR2(1);
1741:
1742: l_payer_notif_flag iby_trxn_summaries_all.payer_notification_required%TYPE;
1743: l_bep_type iby_bepinfo.bep_type%TYPE;
1744:
1745: CURSOR trxn_exists IS
1746: SELECT 'Y', trxnmid, mtangibleid
1747: FROM iby_trxn_summaries_all s
1815: -- get bep_type info
1816: BEGIN
1817: SELECT bep_type
1818: INTO l_bep_type
1819: FROM iby_bepinfo
1820: WHERE bepid = i_bepid;
1821: EXCEPTION
1822: WHEN others THEN NULL;
1823: END;