APPS.CE_BAT_API dependencies on CE_CASHPOOLS

Line 42: G_cp_currency_code CE_CASHPOOLS.currency_code%TYPE := NULL;

38: G_destination_party_site_id HZ_PARTY_SITES.party_site_id%TYPE := NULL;
39:
40:
41: -- Cash pool
42: G_cp_currency_code CE_CASHPOOLS.currency_code%TYPE := NULL;
43: G_cp_cashpool_id CE_CASHPOOLS.cashpool_id%TYPE := NULL;
44: G_cp_authorize_flag VARCHAR2(30) := NULL;
45: G_cp_trxn_subtype_code_id NUMBER := NULL;
46:

Line 43: G_cp_cashpool_id CE_CASHPOOLS.cashpool_id%TYPE := NULL;

39:
40:
41: -- Cash pool
42: G_cp_currency_code CE_CASHPOOLS.currency_code%TYPE := NULL;
43: G_cp_cashpool_id CE_CASHPOOLS.cashpool_id%TYPE := NULL;
44: G_cp_authorize_flag VARCHAR2(30) := NULL;
45: G_cp_trxn_subtype_code_id NUMBER := NULL;
46:
47: -- CL Proposed transfer

Line 111: FROM ce_cashpools

107: IS
108: CURSOR c_cashpool (c_cashpool_id number)
109: IS
110: SELECT authorization_bat
111: FROM ce_cashpools
112: WHERE cashpool_id = c_cashpool_id;
113:
114: l_authorization_bat CE_CASHPOOLS.authorization_bat%TYPE;
115:

Line 114: l_authorization_bat CE_CASHPOOLS.authorization_bat%TYPE;

110: SELECT authorization_bat
111: FROM ce_cashpools
112: WHERE cashpool_id = c_cashpool_id;
113:
114: l_authorization_bat CE_CASHPOOLS.authorization_bat%TYPE;
115:
116: -- Bug 16402102: Added
117: l_debug_proc VARCHAR2(30) := 'check_cashpool';
118: BEGIN

Line 377: FROM ce_cashpools cp

373: INTO G_cp_cashpool_id,
374: G_cp_currency_code,
375: G_cp_authorize_flag,
376: G_cp_trxn_subtype_code_id
377: FROM ce_cashpools cp
378: WHERE cp.cashpool_id = p_cashpool_id;
379:
380: IF (p_called_by = 'ZBA')
381: THEN