APPS.CE_CP_OA_XTR_PKG dependencies on XTR_BANK_ACCOUNTS

Line 5: result XTR_BANK_ACCOUNTS.party_code%TYPE;

1: PACKAGE BODY CE_CP_OA_XTR_PKG AS
2: /* $Header: cecputlb.pls 120.3 2006/01/31 11:19:19 svali ship $ */
3:
4: FUNCTION FIND_COMPANY_CODE(X_bank_account_id NUMBER) RETURN VARCHAR2 IS
5: result XTR_BANK_ACCOUNTS.party_code%TYPE;
6: BEGIN
7:
8: BEGIN
9: SELECT party_code

Line 11: FROM XTR_BANK_ACCOUNTS

7:
8: BEGIN
9: SELECT party_code
10: INTO result
11: FROM XTR_BANK_ACCOUNTS
12: WHERE nvl(ap_bank_account_id, dummy_bank_account_id) = X_bank_account_id;
13: EXCEPTION
14: WHEN NO_DATA_FOUND THEN
15: result := null;