DBA Data[Home] [Help]

APPS.CE_BAT_API dependencies on HZ_PARTY_SITES

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

34: G_source_le_id CE_BANK_ACCOUNTS.account_owner_org_id%TYPE := NULL;
35: G_destination_le_id CE_BANK_ACCOUNTS.account_owner_org_id%TYPE := NULL;
36: G_source_le_party_id XLE_ENTITY_PROFILES.party_id%TYPE := NULL;
37: G_destination_le_party_id XLE_ENTITY_PROFILES.party_id%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;

Line 195: hz_party_sites hps,

191: ba.bank_account_name
192: FROM
193: ce_bank_accounts ba,
194: xle_entity_profiles xfp,
195: hz_party_sites hps,
196: ce_system_parameters sp
197: WHERE
198: ba.bank_account_id = p_cs_bank_account_id
199: AND xfp.legal_entity_id = ba.account_owner_org_id