DBA Data[Home] [Help]

APPS.IBY_SCHED dependencies on IBY_EXT_BANK_ACCOUNTS_V

Line 17: out_bankid_to out nocopy iby_ext_bank_accounts_v.bank_party_id%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,
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,

Line 18: out_branchid_to out nocopy iby_ext_bank_accounts_v.branch_party_id%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,
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,

Line 19: out_acctid_to out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%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,
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,

Line 41: from iby_ext_bank_accounts_v b,

37: select b.bank_party_id,
38: b.branch_party_id,
39: b.ext_bank_account_id,
40: b.bank_account_type
41: from iby_ext_bank_accounts_v b,
42: iby_trxn_summaries_all d
43: where d.payeeid = cin_payeeid
44: and d.payeeinstrid = b.ext_bank_account_id;
45:

Line 89: out_bankid_from out nocopy iby_ext_bank_accounts_v.bank_party_id%type,

85:
86: procedure bankInfo (in_payerinstrid in iby_trans_fi_v.payerinstrid%type,
87: in_payeeid in iby_trans_fi_v.payeeid%type,
88: in_tangibleid in iby_trans_fi_v.tangibleid%type,
89: out_bankid_from out nocopy iby_ext_bank_accounts_v.bank_party_id%type,
90: out_branchid_from out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
91: out_acctid_from out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
92: out_accttype_from out nocopy iby_accttype.accttype%type,
93: out_name out nocopy varchar2,

Line 90: out_branchid_from out nocopy iby_ext_bank_accounts_v.branch_party_id%type,

86: procedure bankInfo (in_payerinstrid in iby_trans_fi_v.payerinstrid%type,
87: in_payeeid in iby_trans_fi_v.payeeid%type,
88: in_tangibleid in iby_trans_fi_v.tangibleid%type,
89: out_bankid_from out nocopy iby_ext_bank_accounts_v.bank_party_id%type,
90: out_branchid_from out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
91: out_acctid_from out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
92: out_accttype_from out nocopy iby_accttype.accttype%type,
93: out_name out nocopy varchar2,
94: out_bankid_to out nocopy iby_ext_bank_accounts_v.bank_party_id%type,

Line 91: out_acctid_from out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,

87: in_payeeid in iby_trans_fi_v.payeeid%type,
88: in_tangibleid in iby_trans_fi_v.tangibleid%type,
89: out_bankid_from out nocopy iby_ext_bank_accounts_v.bank_party_id%type,
90: out_branchid_from out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
91: out_acctid_from out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
92: out_accttype_from out nocopy iby_accttype.accttype%type,
93: out_name out nocopy varchar2,
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,

Line 94: out_bankid_to out nocopy iby_ext_bank_accounts_v.bank_party_id%type,

90: out_branchid_from out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
91: out_acctid_from out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
92: out_accttype_from out nocopy iby_accttype.accttype%type,
93: out_name out nocopy varchar2,
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,

Line 95: out_branchid_to out nocopy iby_ext_bank_accounts_v.branch_party_id%type,

91: out_acctid_from out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
92: out_accttype_from out nocopy iby_accttype.accttype%type,
93: out_name out nocopy varchar2,
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,

Line 96: out_acctid_to out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,

92: out_accttype_from out nocopy iby_accttype.accttype%type,
93: out_name out nocopy varchar2,
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,

Line 109: from iby_ext_bank_accounts_v b,

105: select b.bank_party_id,
106: b.branch_party_id,
107: b.ext_bank_account_id,
108: b.bank_account_type
109: from iby_ext_bank_accounts_v b,
110: iby_trxn_summaries_all d
111: where d.payerinstrid = cin_payerinstrid
112: and d.payerinstrid = b.ext_bank_account_id;
113:

Line 120: from iby_ext_bank_accounts_v b,

116: select b.bank_party_id,
117: b.branch_party_id,
118: b.ext_bank_account_id,
119: b.bank_account_type
120: from iby_ext_bank_accounts_v b,
121: iby_trxn_summaries_all d
122: where d.payeeid = cin_payeeid
123: and d.payeeinstrid = b.ext_bank_account_id;
124: