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 IBY_PAY_INSTRUCTIONS_ALL

Line 31: CURSOR sch_num_csr(p_pinstr_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE)

27: x_error_code OUT NOCOPY NUMBER,
28: x_error_mesg OUT NOCOPY VARCHAR2
29: ) IS
30:
31: CURSOR sch_num_csr(p_pinstr_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE)
32: IS
33: SELECT pay_admin_assigned_ref_code
34: FROM IBY_PAY_INSTRUCTIONS_ALL
35: WHERE payment_instruction_id = p_pinstr_id;

Line 34: FROM IBY_PAY_INSTRUCTIONS_ALL

30:
31: CURSOR sch_num_csr(p_pinstr_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE)
32: IS
33: SELECT pay_admin_assigned_ref_code
34: FROM IBY_PAY_INSTRUCTIONS_ALL
35: WHERE payment_instruction_id = p_pinstr_id;
36:
37:
38: l_constant NUMBER := 1;

Line 1658: l_rfc_id iby_pay_instructions_all.rfc_identifier%TYPE;

1654: )IS
1655:
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:

Line 1659: l_bank_account_id iby_pay_instructions_all.internal_bank_account_id%TYPE;

1655:
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:

Line 1868: from iby_pay_instructions_all ipia,

1864: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1865:
1866: select ipia.org_id, haou.name
1867: into l_org_id, l_org_name
1868: from iby_pay_instructions_all ipia,
1869: hr_all_organization_units haou
1870: where ipia.payment_instruction_id = p_pay_instruction_id
1871: and ipia.org_id = haou.organization_id;
1872: