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_PAYMENT_FORMAT_VAL_PVT dependencies on CE_BANK_ACCOUNTS

Line 1218: p_agency_location_code IN ce_bank_accounts.agency_location_code%TYPE,

1214:
1215: PROCEDURE AGENCY_LOCATION_CODE
1216: (
1217: p_format_name IN VARCHAR2,
1218: p_agency_location_code IN ce_bank_accounts.agency_location_code%TYPE,
1219: p_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,
1220: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1221: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1222: x_error_code OUT NOCOPY NUMBER,

Line 1219: p_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,

1215: PROCEDURE AGENCY_LOCATION_CODE
1216: (
1217: p_format_name IN VARCHAR2,
1218: p_agency_location_code IN ce_bank_accounts.agency_location_code%TYPE,
1219: p_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,
1220: p_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
1221: p_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
1222: x_error_code OUT NOCOPY NUMBER,
1223: x_error_mesg OUT NOCOPY VARCHAR2

Line 1660: l_bank_branch_id ce_bank_accounts.bank_branch_id%TYPE;

1656: l_message VARCHAR2(1000);
1657: l_module_name VARCHAR2(200) := g_module_name || 'RFC_ID';
1658: l_rfc_id iby_pay_instructions_all.rfc_identifier%TYPE;
1659: l_bank_account_id iby_pay_instructions_all.internal_bank_account_id%TYPE;
1660: l_bank_branch_id ce_bank_accounts.bank_branch_id%TYPE;
1661: l_bank_account_name ce_bank_accounts.bank_account_name%TYPE;
1662:
1663:
1664:

Line 1661: l_bank_account_name ce_bank_accounts.bank_account_name%TYPE;

1657: l_module_name VARCHAR2(200) := g_module_name || 'RFC_ID';
1658: l_rfc_id iby_pay_instructions_all.rfc_identifier%TYPE;
1659: l_bank_account_id iby_pay_instructions_all.internal_bank_account_id%TYPE;
1660: l_bank_branch_id ce_bank_accounts.bank_branch_id%TYPE;
1661: l_bank_account_name ce_bank_accounts.bank_account_name%TYPE;
1662:
1663:
1664:
1665:

Line 1681: ce_bank_accounts cba,

1677: l_bank_account_id,
1678: l_bank_branch_id,
1679: l_bank_account_name
1680: from iby_payments_all ipa,
1681: ce_bank_accounts cba,
1682: hz_code_assignments hca
1683: where ipa.payment_id = p_payment_id
1684: and ipa.internal_bank_account_id = cba.bank_account_id(+)
1685: and hca.owner_table_name(+) = 'HZ_PARTIES'