DBA Data[Home] [Help]

APPS.IBY_SCHED dependencies on IBY_CREDITCARD_V

Line 13: out_ccnumber_from out nocopy iby_creditcard_v.ccnumber%type,

9:
10: procedure cardInfo (in_payerinstrid in iby_trans_fi_v.payerinstrid%type,
11: in_payeeid in iby_trans_fi_v.payeeid%type,
12: in_tangibleid in iby_trans_fi_v.tangibleid%type,
13: out_ccnumber_from out nocopy iby_creditcard_v.ccnumber%type,
14: out_expdate_from out nocopy iby_creditcard_v.expirydate%type,
15: out_accttype_from out nocopy iby_accttype.accttype%type,
16: out_name out nocopy varchar2,
17: out_bankid_to out nocopy iby_ext_bank_accounts_v.bank_party_id%type,

Line 14: out_expdate_from out nocopy iby_creditcard_v.expirydate%type,

10: procedure cardInfo (in_payerinstrid in iby_trans_fi_v.payerinstrid%type,
11: in_payeeid in iby_trans_fi_v.payeeid%type,
12: in_tangibleid in iby_trans_fi_v.tangibleid%type,
13: out_ccnumber_from out nocopy iby_creditcard_v.ccnumber%type,
14: out_expdate_from out nocopy iby_creditcard_v.expirydate%type,
15: out_accttype_from out nocopy iby_accttype.accttype%type,
16: out_name out nocopy varchar2,
17: out_bankid_to out nocopy iby_ext_bank_accounts_v.bank_party_id%type,
18: out_branchid_to out nocopy iby_ext_bank_accounts_v.branch_party_id%type,

Line 31: from iby_creditcard_v c,

27:
28: select ccnumber,
29: expirydate,
30: accttype
31: from iby_creditcard_v c,
32: iby_trxn_summaries_all d
33: where d.payerinstrid = cin_payerinstrid
34: and d.payerinstrid = c.instrid;
35: