DBA Data[Home] [Help]

APPS.CE_BAT_API dependencies on HZ_PARTY_SITES

Line 41: G_destination_party_site_id HZ_PARTY_SITES.party_site_id%TYPE := NULL;

37: G_source_le_id CE_BANK_ACCOUNTS.account_owner_org_id%TYPE := NULL;
38: G_destination_le_id CE_BANK_ACCOUNTS.account_owner_org_id%TYPE := NULL;
39: G_source_le_party_id XLE_ENTITY_PROFILES.party_id%TYPE := NULL;
40: G_destination_le_party_id XLE_ENTITY_PROFILES.party_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;

Line 180: hz_party_sites hps,

176: ba.bank_account_name
177: FROM
178: ce_bank_accounts ba,
179: xle_entity_profiles xfp,
180: hz_party_sites hps,
181: ce_system_parameters sp
182: WHERE
183: ba.bank_account_id = p_cs_bank_account_id
184: AND xfp.legal_entity_id = ba.account_owner_org_id