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 1645: l_rfc_id iby_pay_instructions_all.rfc_identifier%TYPE;

1641: )IS
1642:
1643: l_message VARCHAR2(1000);
1644: l_module_name VARCHAR2(200) := g_module_name || 'RFC_ID';
1645: l_rfc_id iby_pay_instructions_all.rfc_identifier%TYPE;
1646: l_bank_account_id iby_pay_instructions_all.internal_bank_account_id%TYPE;
1647: l_bank_branch_id ce_bank_accounts.bank_branch_id%TYPE;
1648: l_bank_account_name ce_bank_accounts.bank_account_name%TYPE;
1649:

Line 1646: l_bank_account_id iby_pay_instructions_all.internal_bank_account_id%TYPE;

1642:
1643: l_message VARCHAR2(1000);
1644: l_module_name VARCHAR2(200) := g_module_name || 'RFC_ID';
1645: l_rfc_id iby_pay_instructions_all.rfc_identifier%TYPE;
1646: l_bank_account_id iby_pay_instructions_all.internal_bank_account_id%TYPE;
1647: l_bank_branch_id ce_bank_accounts.bank_branch_id%TYPE;
1648: l_bank_account_name ce_bank_accounts.bank_account_name%TYPE;
1649:
1650:

Line 1855: from iby_pay_instructions_all ipia,

1851: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1852:
1853: select ipia.org_id, haou.name
1854: into l_org_id, l_org_name
1855: from iby_pay_instructions_all ipia,
1856: hr_all_organization_units haou
1857: where ipia.payment_instruction_id = p_pay_instruction_id
1858: and ipia.org_id = haou.organization_id;
1859: