DBA Data[Home] [Help]

APPS.IBY_PAYMENTMANAGERDB_PKG dependencies on IBY_DEFAULT_BEP

Line 148: l_bepid iby_default_bep.bepid%TYPE;

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

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

1288: IS
1289: SELECT a.bepid,
1290: c.key,
1291: a.fndcpt_user_profile_code
1292: FROM iby_default_bep a, iby_bepinfo b, iby_bepkeys c
1293: WHERE a.payment_channel_code = ci_payment_channel_code
1294: AND a.mpayeeid = ci_mpayeeid
1295: AND a.bepid = b.bepid
1296: AND UPPER(b.activeStatus) = 'Y'