APPS.CE_BAT_API dependencies on CE_CASHPOOLS

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

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

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

44: -- Cash pool
45: G_cp_cashpool_id CE_CASHPOOLS.cashpool_id%TYPE := NULL;
46: G_cp_authorize_flag VARCHAR2(30) := NULL;
47: G_cp_trxn_subtype_code_id NUMBER := NULL;
48: G_cp_currency_code CE_CASHPOOLS.currency_code%TYPE:= NULL;
49:
50: -- CL Proposed transfer
51: G_proposed_transfer_id NUMBER := NULL;
52: G_proposed_as_of_date DATE := NULL;

Line 103: FROM ce_cashpools

99: p_result OUT NOCOPY VARCHAR2)
100: IS
101: CURSOR c_cashpool (c_cashpool_id number)IS
102: SELECT authorization_bat
103: FROM ce_cashpools
104: WHERE cashpool_id = c_cashpool_id;
105:
106: l_authorization_Bat CE_CASHPOOLS.authorization_bat%TYPE;
107: BEGIN

Line 106: l_authorization_Bat CE_CASHPOOLS.authorization_bat%TYPE;

102: SELECT authorization_bat
103: FROM ce_cashpools
104: WHERE cashpool_id = c_cashpool_id;
105:
106: l_authorization_Bat CE_CASHPOOLS.authorization_bat%TYPE;
107: BEGIN
108:
109: OPEN c_Cashpool(p_cashpool_id);
110: FETCH c_cashpool INTO l_authorization_bat;

Line 304: FROM ce_cashpools cp

300: G_cp_cashpool_id,
301: G_cp_currency_code,
302: G_cp_authorize_flag,
303: G_cp_trxn_subtype_code_id
304: FROM ce_cashpools cp
305: WHERE cp.cashpool_id = p_cashpool_id;
306:
307: IF (p_called_by = 'ZBA') THEN
308: -- Fetch Statement line data