APPS.IBY_SCHED dependencies on IBY_TANGIBLE

Line 21: out_acctno out nocopy iby_tangible.acctno%type,

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,
19: out_acctid_to out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
20: out_accttype_to out nocopy iby_accttype.accttype%type,
21: out_acctno out nocopy iby_tangible.acctno%type,
22: out_refinfo out nocopy iby_tangible.refinfo%type,
23: out_memo out nocopy iby_tangible.memo%type,
24: out_currency out nocopy iby_tangible.currencynamecode%type)
25: is

Line 22: out_refinfo out nocopy iby_tangible.refinfo%type,

18: out_branchid_to out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
19: out_acctid_to out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
20: out_accttype_to out nocopy iby_accttype.accttype%type,
21: out_acctno out nocopy iby_tangible.acctno%type,
22: out_refinfo out nocopy iby_tangible.refinfo%type,
23: out_memo out nocopy iby_tangible.memo%type,
24: out_currency out nocopy iby_tangible.currencynamecode%type)
25: is
26: cursor c_userCardInfo (cin_payerinstrid in iby_trans_fi_v.payerinstrid%type) is

Line 23: out_memo out nocopy iby_tangible.memo%type,

19: out_acctid_to out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
20: out_accttype_to out nocopy iby_accttype.accttype%type,
21: out_acctno out nocopy iby_tangible.acctno%type,
22: out_refinfo out nocopy iby_tangible.refinfo%type,
23: out_memo out nocopy iby_tangible.memo%type,
24: out_currency out nocopy iby_tangible.currencynamecode%type)
25: is
26: cursor c_userCardInfo (cin_payerinstrid in iby_trans_fi_v.payerinstrid%type) is
27:

Line 24: out_currency out nocopy iby_tangible.currencynamecode%type)

20: out_accttype_to out nocopy iby_accttype.accttype%type,
21: out_acctno out nocopy iby_tangible.acctno%type,
22: out_refinfo out nocopy iby_tangible.refinfo%type,
23: out_memo out nocopy iby_tangible.memo%type,
24: out_currency out nocopy iby_tangible.currencynamecode%type)
25: is
26: cursor c_userCardInfo (cin_payerinstrid in iby_trans_fi_v.payerinstrid%type) is
27:
28: select ccnumber,

Line 51: from iby_tangible t

47: select acctno,
48: refinfo,
49: memo,
50: currencynamecode
51: from iby_tangible t
52: where t.tangibleid = cin_tangibleid;
53: BEGIN
54: -- get the user's credit card information
55: open c_userCardInfo(in_payerinstrid);

Line 98: out_acctno out nocopy iby_tangible.acctno%type,

94: out_bankid_to out nocopy iby_ext_bank_accounts_v.bank_party_id%type,
95: out_branchid_to out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
96: out_acctid_to out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
97: out_accttype_to out nocopy iby_accttype.accttype%type,
98: out_acctno out nocopy iby_tangible.acctno%type,
99: out_refinfo out nocopy iby_tangible.refinfo%type,
100: out_memo out nocopy iby_tangible.memo%type,
101: out_currency out nocopy iby_tangible.currencynamecode%type)
102: is

Line 99: out_refinfo out nocopy iby_tangible.refinfo%type,

95: out_branchid_to out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
96: out_acctid_to out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
97: out_accttype_to out nocopy iby_accttype.accttype%type,
98: out_acctno out nocopy iby_tangible.acctno%type,
99: out_refinfo out nocopy iby_tangible.refinfo%type,
100: out_memo out nocopy iby_tangible.memo%type,
101: out_currency out nocopy iby_tangible.currencynamecode%type)
102: is
103: cursor c_userBankInfo (cin_payerinstrid in iby_trans_fi_v.payerinstrid%type) is

Line 100: out_memo out nocopy iby_tangible.memo%type,

96: out_acctid_to out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
97: out_accttype_to out nocopy iby_accttype.accttype%type,
98: out_acctno out nocopy iby_tangible.acctno%type,
99: out_refinfo out nocopy iby_tangible.refinfo%type,
100: out_memo out nocopy iby_tangible.memo%type,
101: out_currency out nocopy iby_tangible.currencynamecode%type)
102: is
103: cursor c_userBankInfo (cin_payerinstrid in iby_trans_fi_v.payerinstrid%type) is
104:

Line 101: out_currency out nocopy iby_tangible.currencynamecode%type)

97: out_accttype_to out nocopy iby_accttype.accttype%type,
98: out_acctno out nocopy iby_tangible.acctno%type,
99: out_refinfo out nocopy iby_tangible.refinfo%type,
100: out_memo out nocopy iby_tangible.memo%type,
101: out_currency out nocopy iby_tangible.currencynamecode%type)
102: is
103: cursor c_userBankInfo (cin_payerinstrid in iby_trans_fi_v.payerinstrid%type) is
104:
105: select b.bank_party_id,

Line 130: from iby_tangible t

126: select acctno,
127: refinfo,
128: memo,
129: currencynamecode
130: from iby_tangible t
131: where t.tangibleid = cin_tangibleid;
132: begin
133: -- get the user's bank account information
134: open c_userBankInfo (in_payerinstrid);