APPS.IBY_ACCPPMTMTHD_PKG dependencies on IBY_PAYEE

Line 6: ** Purpose: retrieve mpayeeid from iby_payee table based on payeeid

2: /*$Header: ibyacpmb.pls 115.7 2002/11/15 23:45:00 jleybovi ship $*/
3:
4: /*
5: ** Procedure: getMPayeeId
6: ** Purpose: retrieve mpayeeid from iby_payee table based on payeeid
7: */
8: Procedure getMPayeeId(i_payeeid in iby_payee.payeeid%type,
9: o_mpayeeid out nocopy iby_payee.mpayeeid%type)
10: is

Line 8: Procedure getMPayeeId(i_payeeid in iby_payee.payeeid%type,

4: /*
5: ** Procedure: getMPayeeId
6: ** Purpose: retrieve mpayeeid from iby_payee table based on payeeid
7: */
8: Procedure getMPayeeId(i_payeeid in iby_payee.payeeid%type,
9: o_mpayeeid out nocopy iby_payee.mpayeeid%type)
10: is
11: cursor c_get_mpayeeid(ci_payeeid iby_payee.payeeid%type) is
12: SELECT mpayeeid from iby_payee

Line 9: o_mpayeeid out nocopy iby_payee.mpayeeid%type)

5: ** Procedure: getMPayeeId
6: ** Purpose: retrieve mpayeeid from iby_payee table based on payeeid
7: */
8: Procedure getMPayeeId(i_payeeid in iby_payee.payeeid%type,
9: o_mpayeeid out nocopy iby_payee.mpayeeid%type)
10: is
11: cursor c_get_mpayeeid(ci_payeeid iby_payee.payeeid%type) is
12: SELECT mpayeeid from iby_payee
13: WHERE payeeid = ci_payeeid;

Line 11: cursor c_get_mpayeeid(ci_payeeid iby_payee.payeeid%type) is

7: */
8: Procedure getMPayeeId(i_payeeid in iby_payee.payeeid%type,
9: o_mpayeeid out nocopy iby_payee.mpayeeid%type)
10: is
11: cursor c_get_mpayeeid(ci_payeeid iby_payee.payeeid%type) is
12: SELECT mpayeeid from iby_payee
13: WHERE payeeid = ci_payeeid;
14: BEGIN
15: open c_get_mpayeeid(i_payeeid);

Line 12: SELECT mpayeeid from iby_payee

8: Procedure getMPayeeId(i_payeeid in iby_payee.payeeid%type,
9: o_mpayeeid out nocopy iby_payee.mpayeeid%type)
10: is
11: cursor c_get_mpayeeid(ci_payeeid iby_payee.payeeid%type) is
12: SELECT mpayeeid from iby_payee
13: WHERE payeeid = ci_payeeid;
14: BEGIN
15: open c_get_mpayeeid(i_payeeid);
16: fetch c_get_mpayeeid into o_mpayeeid;