DBA Data[Home] [Help]

APPS.IBY_SCHED dependencies on IBY_EXT_BANK_ACCOUNTS_V

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

7: out_ccnumber_from out nocopy iby_creditcard_v.ccnumber%type,
8: out_expdate_from out nocopy iby_creditcard_v.expirydate%type,
9: out_accttype_from out nocopy iby_accttype.accttype%type,
10: out_name out nocopy varchar2,
11: out_bankid_to out nocopy iby_ext_bank_accounts_v.bank_party_id%type,
12: out_branchid_to out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
13: out_acctid_to out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
14: out_accttype_to out nocopy iby_accttype.accttype%type,
15: out_acctno out nocopy iby_tangible.acctno%type,

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

8: out_expdate_from out nocopy iby_creditcard_v.expirydate%type,
9: out_accttype_from out nocopy iby_accttype.accttype%type,
10: out_name out nocopy varchar2,
11: out_bankid_to out nocopy iby_ext_bank_accounts_v.bank_party_id%type,
12: out_branchid_to out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
13: out_acctid_to out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
14: out_accttype_to out nocopy iby_accttype.accttype%type,
15: out_acctno out nocopy iby_tangible.acctno%type,
16: out_refinfo out nocopy iby_tangible.refinfo%type,

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

9: out_accttype_from out nocopy iby_accttype.accttype%type,
10: out_name out nocopy varchar2,
11: out_bankid_to out nocopy iby_ext_bank_accounts_v.bank_party_id%type,
12: out_branchid_to out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
13: out_acctid_to out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
14: out_accttype_to out nocopy iby_accttype.accttype%type,
15: out_acctno out nocopy iby_tangible.acctno%type,
16: out_refinfo out nocopy iby_tangible.refinfo%type,
17: out_memo out nocopy iby_tangible.memo%type,

Line 35: from iby_ext_bank_accounts_v b,

31: select b.bank_party_id,
32: b.branch_party_id,
33: b.ext_bank_account_id,
34: b.bank_account_type
35: from iby_ext_bank_accounts_v b,
36: iby_trxn_summaries_all d
37: where d.payeeid = cin_payeeid
38: and d.payeeinstrid = b.ext_bank_account_id;
39:

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

79:
80: procedure bankInfo (in_payerinstrid in iby_trans_fi_v.payerinstrid%type,
81: in_payeeid in iby_trans_fi_v.payeeid%type,
82: in_tangibleid in iby_trans_fi_v.tangibleid%type,
83: out_bankid_from out nocopy iby_ext_bank_accounts_v.bank_party_id%type,
84: out_branchid_from out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
85: out_acctid_from out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
86: out_accttype_from out nocopy iby_accttype.accttype%type,
87: out_name out nocopy varchar2,

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

80: procedure bankInfo (in_payerinstrid in iby_trans_fi_v.payerinstrid%type,
81: in_payeeid in iby_trans_fi_v.payeeid%type,
82: in_tangibleid in iby_trans_fi_v.tangibleid%type,
83: out_bankid_from out nocopy iby_ext_bank_accounts_v.bank_party_id%type,
84: out_branchid_from out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
85: out_acctid_from out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
86: out_accttype_from out nocopy iby_accttype.accttype%type,
87: out_name out nocopy varchar2,
88: out_bankid_to out nocopy iby_ext_bank_accounts_v.bank_party_id%type,

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

81: in_payeeid in iby_trans_fi_v.payeeid%type,
82: in_tangibleid in iby_trans_fi_v.tangibleid%type,
83: out_bankid_from out nocopy iby_ext_bank_accounts_v.bank_party_id%type,
84: out_branchid_from out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
85: out_acctid_from out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
86: out_accttype_from out nocopy iby_accttype.accttype%type,
87: out_name out nocopy varchar2,
88: out_bankid_to out nocopy iby_ext_bank_accounts_v.bank_party_id%type,
89: out_branchid_to out nocopy iby_ext_bank_accounts_v.branch_party_id%type,

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

84: out_branchid_from out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
85: out_acctid_from out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
86: out_accttype_from out nocopy iby_accttype.accttype%type,
87: out_name out nocopy varchar2,
88: out_bankid_to out nocopy iby_ext_bank_accounts_v.bank_party_id%type,
89: out_branchid_to out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
90: out_acctid_to out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
91: out_accttype_to out nocopy iby_accttype.accttype%type,
92: out_acctno out nocopy iby_tangible.acctno%type,

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

85: out_acctid_from out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
86: out_accttype_from out nocopy iby_accttype.accttype%type,
87: out_name out nocopy varchar2,
88: out_bankid_to out nocopy iby_ext_bank_accounts_v.bank_party_id%type,
89: out_branchid_to out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
90: out_acctid_to out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
91: out_accttype_to out nocopy iby_accttype.accttype%type,
92: out_acctno out nocopy iby_tangible.acctno%type,
93: out_refinfo out nocopy iby_tangible.refinfo%type,

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

86: out_accttype_from out nocopy iby_accttype.accttype%type,
87: out_name out nocopy varchar2,
88: out_bankid_to out nocopy iby_ext_bank_accounts_v.bank_party_id%type,
89: out_branchid_to out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
90: out_acctid_to out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
91: out_accttype_to out nocopy iby_accttype.accttype%type,
92: out_acctno out nocopy iby_tangible.acctno%type,
93: out_refinfo out nocopy iby_tangible.refinfo%type,
94: out_memo out nocopy iby_tangible.memo%type,

Line 103: from iby_ext_bank_accounts_v b,

99: select b.bank_party_id,
100: b.branch_party_id,
101: b.ext_bank_account_id,
102: b.bank_account_type
103: from iby_ext_bank_accounts_v b,
104: iby_trxn_summaries_all d
105: where d.payerinstrid = cin_payerinstrid
106: and d.payerinstrid = b.ext_bank_account_id;
107:

Line 114: from iby_ext_bank_accounts_v b,

110: select b.bank_party_id,
111: b.branch_party_id,
112: b.ext_bank_account_id,
113: b.bank_account_type
114: from iby_ext_bank_accounts_v b,
115: iby_trxn_summaries_all d
116: where d.payeeid = cin_payeeid
117: and d.payeeinstrid = b.ext_bank_account_id;
118: