eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_DISBURSEMENT_COMP_PUB dependencies on IBY_EXT_BANK_ACCOUNTS_V

Line 29: Payee_BankAccount_Name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,

25: Payee_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
26: Payee_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
27: Payment_Currency IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
28: Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,
29: Payee_BankAccount_Name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
30: Payee_BankAccount_Id IBY_EXT_BANK_ACCOUNTS_V.ext_bank_account_id%TYPE,
31: Payee_BankAccount_Num IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,
32: Currency_Code IBY_EXT_BANK_ACCOUNTS_V.CURRENCY_CODE%TYPE,
33: IBAN IBY_EXT_BANK_ACCOUNTS_V.IBAN_NUMBER%TYPE,

Line 30: Payee_BankAccount_Id IBY_EXT_BANK_ACCOUNTS_V.ext_bank_account_id%TYPE,

26: Payee_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
27: Payment_Currency IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
28: Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,
29: Payee_BankAccount_Name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
30: Payee_BankAccount_Id IBY_EXT_BANK_ACCOUNTS_V.ext_bank_account_id%TYPE,
31: Payee_BankAccount_Num IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,
32: Currency_Code IBY_EXT_BANK_ACCOUNTS_V.CURRENCY_CODE%TYPE,
33: IBAN IBY_EXT_BANK_ACCOUNTS_V.IBAN_NUMBER%TYPE,
34: Payee_BankName IBY_EXT_BANK_ACCOUNTS_V.BANK_NAME%TYPE,

Line 31: Payee_BankAccount_Num IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,

27: Payment_Currency IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
28: Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,
29: Payee_BankAccount_Name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
30: Payee_BankAccount_Id IBY_EXT_BANK_ACCOUNTS_V.ext_bank_account_id%TYPE,
31: Payee_BankAccount_Num IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,
32: Currency_Code IBY_EXT_BANK_ACCOUNTS_V.CURRENCY_CODE%TYPE,
33: IBAN IBY_EXT_BANK_ACCOUNTS_V.IBAN_NUMBER%TYPE,
34: Payee_BankName IBY_EXT_BANK_ACCOUNTS_V.BANK_NAME%TYPE,
35: Payee_BankNumber IBY_EXT_BANK_ACCOUNTS_V.BANK_NUMBER%TYPE,

Line 32: Currency_Code IBY_EXT_BANK_ACCOUNTS_V.CURRENCY_CODE%TYPE,

28: Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,
29: Payee_BankAccount_Name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
30: Payee_BankAccount_Id IBY_EXT_BANK_ACCOUNTS_V.ext_bank_account_id%TYPE,
31: Payee_BankAccount_Num IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,
32: Currency_Code IBY_EXT_BANK_ACCOUNTS_V.CURRENCY_CODE%TYPE,
33: IBAN IBY_EXT_BANK_ACCOUNTS_V.IBAN_NUMBER%TYPE,
34: Payee_BankName IBY_EXT_BANK_ACCOUNTS_V.BANK_NAME%TYPE,
35: Payee_BankNumber IBY_EXT_BANK_ACCOUNTS_V.BANK_NUMBER%TYPE,
36: Payee_BranchName IBY_EXT_BANK_ACCOUNTS_V.BANK_BRANCH_NAME%TYPE,

Line 33: IBAN IBY_EXT_BANK_ACCOUNTS_V.IBAN_NUMBER%TYPE,

29: Payee_BankAccount_Name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
30: Payee_BankAccount_Id IBY_EXT_BANK_ACCOUNTS_V.ext_bank_account_id%TYPE,
31: Payee_BankAccount_Num IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,
32: Currency_Code IBY_EXT_BANK_ACCOUNTS_V.CURRENCY_CODE%TYPE,
33: IBAN IBY_EXT_BANK_ACCOUNTS_V.IBAN_NUMBER%TYPE,
34: Payee_BankName IBY_EXT_BANK_ACCOUNTS_V.BANK_NAME%TYPE,
35: Payee_BankNumber IBY_EXT_BANK_ACCOUNTS_V.BANK_NUMBER%TYPE,
36: Payee_BranchName IBY_EXT_BANK_ACCOUNTS_V.BANK_BRANCH_NAME%TYPE,
37: Payee_BranchNumber IBY_EXT_BANK_ACCOUNTS_V.BRANCH_NUMBER%TYPE,

Line 34: Payee_BankName IBY_EXT_BANK_ACCOUNTS_V.BANK_NAME%TYPE,

30: Payee_BankAccount_Id IBY_EXT_BANK_ACCOUNTS_V.ext_bank_account_id%TYPE,
31: Payee_BankAccount_Num IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,
32: Currency_Code IBY_EXT_BANK_ACCOUNTS_V.CURRENCY_CODE%TYPE,
33: IBAN IBY_EXT_BANK_ACCOUNTS_V.IBAN_NUMBER%TYPE,
34: Payee_BankName IBY_EXT_BANK_ACCOUNTS_V.BANK_NAME%TYPE,
35: Payee_BankNumber IBY_EXT_BANK_ACCOUNTS_V.BANK_NUMBER%TYPE,
36: Payee_BranchName IBY_EXT_BANK_ACCOUNTS_V.BANK_BRANCH_NAME%TYPE,
37: Payee_BranchNumber IBY_EXT_BANK_ACCOUNTS_V.BRANCH_NUMBER%TYPE,
38: Bank_Country IBY_EXT_BANK_ACCOUNTS_V.COUNTRY_CODE%TYPE,

Line 35: Payee_BankNumber IBY_EXT_BANK_ACCOUNTS_V.BANK_NUMBER%TYPE,

31: Payee_BankAccount_Num IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,
32: Currency_Code IBY_EXT_BANK_ACCOUNTS_V.CURRENCY_CODE%TYPE,
33: IBAN IBY_EXT_BANK_ACCOUNTS_V.IBAN_NUMBER%TYPE,
34: Payee_BankName IBY_EXT_BANK_ACCOUNTS_V.BANK_NAME%TYPE,
35: Payee_BankNumber IBY_EXT_BANK_ACCOUNTS_V.BANK_NUMBER%TYPE,
36: Payee_BranchName IBY_EXT_BANK_ACCOUNTS_V.BANK_BRANCH_NAME%TYPE,
37: Payee_BranchNumber IBY_EXT_BANK_ACCOUNTS_V.BRANCH_NUMBER%TYPE,
38: Bank_Country IBY_EXT_BANK_ACCOUNTS_V.COUNTRY_CODE%TYPE,
39: Alter_BankAccount_Name IBY_EXT_BANK_ACCOUNTS_V.ALTERNATE_ACCOUNT_NAME%TYPE,

Line 36: Payee_BranchName IBY_EXT_BANK_ACCOUNTS_V.BANK_BRANCH_NAME%TYPE,

32: Currency_Code IBY_EXT_BANK_ACCOUNTS_V.CURRENCY_CODE%TYPE,
33: IBAN IBY_EXT_BANK_ACCOUNTS_V.IBAN_NUMBER%TYPE,
34: Payee_BankName IBY_EXT_BANK_ACCOUNTS_V.BANK_NAME%TYPE,
35: Payee_BankNumber IBY_EXT_BANK_ACCOUNTS_V.BANK_NUMBER%TYPE,
36: Payee_BranchName IBY_EXT_BANK_ACCOUNTS_V.BANK_BRANCH_NAME%TYPE,
37: Payee_BranchNumber IBY_EXT_BANK_ACCOUNTS_V.BRANCH_NUMBER%TYPE,
38: Bank_Country IBY_EXT_BANK_ACCOUNTS_V.COUNTRY_CODE%TYPE,
39: Alter_BankAccount_Name IBY_EXT_BANK_ACCOUNTS_V.ALTERNATE_ACCOUNT_NAME%TYPE,
40: BankAccount_Type IBY_EXT_BANK_ACCOUNTS_V.BANK_ACCOUNT_TYPE%TYPE,

Line 37: Payee_BranchNumber IBY_EXT_BANK_ACCOUNTS_V.BRANCH_NUMBER%TYPE,

33: IBAN IBY_EXT_BANK_ACCOUNTS_V.IBAN_NUMBER%TYPE,
34: Payee_BankName IBY_EXT_BANK_ACCOUNTS_V.BANK_NAME%TYPE,
35: Payee_BankNumber IBY_EXT_BANK_ACCOUNTS_V.BANK_NUMBER%TYPE,
36: Payee_BranchName IBY_EXT_BANK_ACCOUNTS_V.BANK_BRANCH_NAME%TYPE,
37: Payee_BranchNumber IBY_EXT_BANK_ACCOUNTS_V.BRANCH_NUMBER%TYPE,
38: Bank_Country IBY_EXT_BANK_ACCOUNTS_V.COUNTRY_CODE%TYPE,
39: Alter_BankAccount_Name IBY_EXT_BANK_ACCOUNTS_V.ALTERNATE_ACCOUNT_NAME%TYPE,
40: BankAccount_Type IBY_EXT_BANK_ACCOUNTS_V.BANK_ACCOUNT_TYPE%TYPE,
41: BankAccount_Suffix IBY_EXT_BANK_ACCOUNTS_V.ACCOUNT_SUFFIX%TYPE,

Line 38: Bank_Country IBY_EXT_BANK_ACCOUNTS_V.COUNTRY_CODE%TYPE,

34: Payee_BankName IBY_EXT_BANK_ACCOUNTS_V.BANK_NAME%TYPE,
35: Payee_BankNumber IBY_EXT_BANK_ACCOUNTS_V.BANK_NUMBER%TYPE,
36: Payee_BranchName IBY_EXT_BANK_ACCOUNTS_V.BANK_BRANCH_NAME%TYPE,
37: Payee_BranchNumber IBY_EXT_BANK_ACCOUNTS_V.BRANCH_NUMBER%TYPE,
38: Bank_Country IBY_EXT_BANK_ACCOUNTS_V.COUNTRY_CODE%TYPE,
39: Alter_BankAccount_Name IBY_EXT_BANK_ACCOUNTS_V.ALTERNATE_ACCOUNT_NAME%TYPE,
40: BankAccount_Type IBY_EXT_BANK_ACCOUNTS_V.BANK_ACCOUNT_TYPE%TYPE,
41: BankAccount_Suffix IBY_EXT_BANK_ACCOUNTS_V.ACCOUNT_SUFFIX%TYPE,
42: BankAccount_Desc IBY_EXT_BANK_ACCOUNTS_V.DESCRIPTION%TYPE,

Line 39: Alter_BankAccount_Name IBY_EXT_BANK_ACCOUNTS_V.ALTERNATE_ACCOUNT_NAME%TYPE,

35: Payee_BankNumber IBY_EXT_BANK_ACCOUNTS_V.BANK_NUMBER%TYPE,
36: Payee_BranchName IBY_EXT_BANK_ACCOUNTS_V.BANK_BRANCH_NAME%TYPE,
37: Payee_BranchNumber IBY_EXT_BANK_ACCOUNTS_V.BRANCH_NUMBER%TYPE,
38: Bank_Country IBY_EXT_BANK_ACCOUNTS_V.COUNTRY_CODE%TYPE,
39: Alter_BankAccount_Name IBY_EXT_BANK_ACCOUNTS_V.ALTERNATE_ACCOUNT_NAME%TYPE,
40: BankAccount_Type IBY_EXT_BANK_ACCOUNTS_V.BANK_ACCOUNT_TYPE%TYPE,
41: BankAccount_Suffix IBY_EXT_BANK_ACCOUNTS_V.ACCOUNT_SUFFIX%TYPE,
42: BankAccount_Desc IBY_EXT_BANK_ACCOUNTS_V.DESCRIPTION%TYPE,
43: Foreign_PayUse_Flag IBY_EXT_BANK_ACCOUNTS_V.FOREIGN_PAYMENT_USE_FLAG%TYPE,

Line 40: BankAccount_Type IBY_EXT_BANK_ACCOUNTS_V.BANK_ACCOUNT_TYPE%TYPE,

36: Payee_BranchName IBY_EXT_BANK_ACCOUNTS_V.BANK_BRANCH_NAME%TYPE,
37: Payee_BranchNumber IBY_EXT_BANK_ACCOUNTS_V.BRANCH_NUMBER%TYPE,
38: Bank_Country IBY_EXT_BANK_ACCOUNTS_V.COUNTRY_CODE%TYPE,
39: Alter_BankAccount_Name IBY_EXT_BANK_ACCOUNTS_V.ALTERNATE_ACCOUNT_NAME%TYPE,
40: BankAccount_Type IBY_EXT_BANK_ACCOUNTS_V.BANK_ACCOUNT_TYPE%TYPE,
41: BankAccount_Suffix IBY_EXT_BANK_ACCOUNTS_V.ACCOUNT_SUFFIX%TYPE,
42: BankAccount_Desc IBY_EXT_BANK_ACCOUNTS_V.DESCRIPTION%TYPE,
43: Foreign_PayUse_Flag IBY_EXT_BANK_ACCOUNTS_V.FOREIGN_PAYMENT_USE_FLAG%TYPE,
44: Pay_Factor_Flag IBY_EXT_BANK_ACCOUNTS_V.PAYMENT_FACTOR_FLAG%TYPE,

Line 41: BankAccount_Suffix IBY_EXT_BANK_ACCOUNTS_V.ACCOUNT_SUFFIX%TYPE,

37: Payee_BranchNumber IBY_EXT_BANK_ACCOUNTS_V.BRANCH_NUMBER%TYPE,
38: Bank_Country IBY_EXT_BANK_ACCOUNTS_V.COUNTRY_CODE%TYPE,
39: Alter_BankAccount_Name IBY_EXT_BANK_ACCOUNTS_V.ALTERNATE_ACCOUNT_NAME%TYPE,
40: BankAccount_Type IBY_EXT_BANK_ACCOUNTS_V.BANK_ACCOUNT_TYPE%TYPE,
41: BankAccount_Suffix IBY_EXT_BANK_ACCOUNTS_V.ACCOUNT_SUFFIX%TYPE,
42: BankAccount_Desc IBY_EXT_BANK_ACCOUNTS_V.DESCRIPTION%TYPE,
43: Foreign_PayUse_Flag IBY_EXT_BANK_ACCOUNTS_V.FOREIGN_PAYMENT_USE_FLAG%TYPE,
44: Pay_Factor_Flag IBY_EXT_BANK_ACCOUNTS_V.PAYMENT_FACTOR_FLAG%TYPE,
45: EFT_Swift_Code IBY_EXT_BANK_ACCOUNTS_V.EFT_SWIFT_CODE%TYPE

Line 42: BankAccount_Desc IBY_EXT_BANK_ACCOUNTS_V.DESCRIPTION%TYPE,

38: Bank_Country IBY_EXT_BANK_ACCOUNTS_V.COUNTRY_CODE%TYPE,
39: Alter_BankAccount_Name IBY_EXT_BANK_ACCOUNTS_V.ALTERNATE_ACCOUNT_NAME%TYPE,
40: BankAccount_Type IBY_EXT_BANK_ACCOUNTS_V.BANK_ACCOUNT_TYPE%TYPE,
41: BankAccount_Suffix IBY_EXT_BANK_ACCOUNTS_V.ACCOUNT_SUFFIX%TYPE,
42: BankAccount_Desc IBY_EXT_BANK_ACCOUNTS_V.DESCRIPTION%TYPE,
43: Foreign_PayUse_Flag IBY_EXT_BANK_ACCOUNTS_V.FOREIGN_PAYMENT_USE_FLAG%TYPE,
44: Pay_Factor_Flag IBY_EXT_BANK_ACCOUNTS_V.PAYMENT_FACTOR_FLAG%TYPE,
45: EFT_Swift_Code IBY_EXT_BANK_ACCOUNTS_V.EFT_SWIFT_CODE%TYPE
46: );

Line 43: Foreign_PayUse_Flag IBY_EXT_BANK_ACCOUNTS_V.FOREIGN_PAYMENT_USE_FLAG%TYPE,

39: Alter_BankAccount_Name IBY_EXT_BANK_ACCOUNTS_V.ALTERNATE_ACCOUNT_NAME%TYPE,
40: BankAccount_Type IBY_EXT_BANK_ACCOUNTS_V.BANK_ACCOUNT_TYPE%TYPE,
41: BankAccount_Suffix IBY_EXT_BANK_ACCOUNTS_V.ACCOUNT_SUFFIX%TYPE,
42: BankAccount_Desc IBY_EXT_BANK_ACCOUNTS_V.DESCRIPTION%TYPE,
43: Foreign_PayUse_Flag IBY_EXT_BANK_ACCOUNTS_V.FOREIGN_PAYMENT_USE_FLAG%TYPE,
44: Pay_Factor_Flag IBY_EXT_BANK_ACCOUNTS_V.PAYMENT_FACTOR_FLAG%TYPE,
45: EFT_Swift_Code IBY_EXT_BANK_ACCOUNTS_V.EFT_SWIFT_CODE%TYPE
46: );
47: TYPE t_payee_bankacct_tbl_type IS TABLE OF t_payee_bankacct_rec_type INDEX BY VARCHAR2(2000);

Line 44: Pay_Factor_Flag IBY_EXT_BANK_ACCOUNTS_V.PAYMENT_FACTOR_FLAG%TYPE,

40: BankAccount_Type IBY_EXT_BANK_ACCOUNTS_V.BANK_ACCOUNT_TYPE%TYPE,
41: BankAccount_Suffix IBY_EXT_BANK_ACCOUNTS_V.ACCOUNT_SUFFIX%TYPE,
42: BankAccount_Desc IBY_EXT_BANK_ACCOUNTS_V.DESCRIPTION%TYPE,
43: Foreign_PayUse_Flag IBY_EXT_BANK_ACCOUNTS_V.FOREIGN_PAYMENT_USE_FLAG%TYPE,
44: Pay_Factor_Flag IBY_EXT_BANK_ACCOUNTS_V.PAYMENT_FACTOR_FLAG%TYPE,
45: EFT_Swift_Code IBY_EXT_BANK_ACCOUNTS_V.EFT_SWIFT_CODE%TYPE
46: );
47: TYPE t_payee_bankacct_tbl_type IS TABLE OF t_payee_bankacct_rec_type INDEX BY VARCHAR2(2000);
48: t_payee_bankacct_tbl t_payee_bankacct_tbl_type;

Line 45: EFT_Swift_Code IBY_EXT_BANK_ACCOUNTS_V.EFT_SWIFT_CODE%TYPE

41: BankAccount_Suffix IBY_EXT_BANK_ACCOUNTS_V.ACCOUNT_SUFFIX%TYPE,
42: BankAccount_Desc IBY_EXT_BANK_ACCOUNTS_V.DESCRIPTION%TYPE,
43: Foreign_PayUse_Flag IBY_EXT_BANK_ACCOUNTS_V.FOREIGN_PAYMENT_USE_FLAG%TYPE,
44: Pay_Factor_Flag IBY_EXT_BANK_ACCOUNTS_V.PAYMENT_FACTOR_FLAG%TYPE,
45: EFT_Swift_Code IBY_EXT_BANK_ACCOUNTS_V.EFT_SWIFT_CODE%TYPE
46: );
47: TYPE t_payee_bankacct_tbl_type IS TABLE OF t_payee_bankacct_rec_type INDEX BY VARCHAR2(2000);
48: t_payee_bankacct_tbl t_payee_bankacct_tbl_type;
49:

Line 286: IBY_EXT_BANK_ACCOUNTS_V b,

282: b.foreign_payment_use_flag,
283: b.payment_factor_flag,
284: b.eft_swift_code
285: FROM IBY_PMT_INSTR_USES_ALL ibyu,
286: IBY_EXT_BANK_ACCOUNTS_V b,
287: IBY_EXTERNAL_PAYEES_ALL ibypayee
288: WHERE ibyu.instrument_id = b.ext_bank_account_id
289: AND ibyu.instrument_type = 'BANKACCOUNT'
290: AND (b.currency_code = p_payment_currency OR b.currency_code is null)

Line 2140: IBY_EXT_BANK_ACCOUNTS_V b,

2136: b.foreign_payment_use_flag,
2137: b.payment_factor_flag,
2138: b.eft_swift_code
2139: FROM IBY_PMT_INSTR_USES_ALL ibyu,
2140: IBY_EXT_BANK_ACCOUNTS_V b,
2141: IBY_EXTERNAL_PAYEES_ALL ibypayee
2142: WHERE ibyu.instrument_id = b.ext_bank_account_id
2143: AND ibyu.instrument_type = 'BANKACCOUNT'
2144: AND (b.currency_code = p_payment_currency

Line 2664: IBY_EXT_BANK_ACCOUNTS_V b,

2660: b.foreign_payment_use_flag,
2661: b.payment_factor_flag,
2662: b.eft_swift_code
2663: FROM IBY_PMT_INSTR_USES_ALL ibyu,
2664: IBY_EXT_BANK_ACCOUNTS_V b,
2665: IBY_EXTERNAL_PAYEES_ALL ibypayee
2666: WHERE ibyu.instrument_id = b.ext_bank_account_id
2667: AND ibyu.instrument_type = 'BANKACCOUNT'
2668: AND (b.currency_code = p_payment_currency

Line 3571: IBY_EXT_BANK_ACCOUNTS_V b,

3567: b.foreign_payment_use_flag,
3568: b.payment_factor_flag,
3569: b.eft_swift_code
3570: FROM IBY_PMT_INSTR_USES_ALL ibyu,
3571: IBY_EXT_BANK_ACCOUNTS_V b,
3572: IBY_EXTERNAL_PAYEES_ALL ibypayee
3573: WHERE ibyu.instrument_id = b.ext_bank_account_id
3574: AND ibyu.instrument_type = 'BANKACCOUNT'
3575: AND (b.currency_code = p_payment_currency OR b.currency_code is null)