DBA Data[Home] [Help]

APPS.IBY_PAYMENTMANAGERDB_PKG dependencies on IBY_DEFAULT_BEP

Line 146: l_bepid iby_default_bep.bepid%TYPE;

142: IS
143: l_api_name CONSTANT VARCHAR2(30) := 'listbep';
144: l_module_name CONSTANT VARCHAR2(200) := G_DEBUG_MODULE || '.' ||
145: l_api_name;
146: l_bepid iby_default_bep.bepid%TYPE;
147: l_base_url iby_bepinfo.baseurl%TYPE;
148: l_pay_op VARCHAR2(100);
149: l_routing_fields RoutingAPIFields_rec_type;
150:

Line 1222: FROM iby_default_bep a, iby_bepinfo b, iby_bepkeys c

1218: IS
1219: SELECT a.bepid,
1220: c.key,
1221: a.fndcpt_user_profile_code
1222: FROM iby_default_bep a, iby_bepinfo b, iby_bepkeys c
1223: WHERE a.payment_channel_code = ci_payment_channel_code
1224: AND a.mpayeeid = ci_mpayeeid
1225: AND a.bepid = b.bepid
1226: AND UPPER(b.activeStatus) = 'Y'