DBA Data[Home] [Help]

APPS.AR_CMGT_PARTY_SEARCH dependencies on ARH_ADDR_PKG

Line 84: ARH_ADDR_PKG.FORMAT_ADDRESS(LOC.ADDRESS_STYLE,LOC.ADDRESS1,

80:
81: --The partySearchResults cursor
82: CURSOR partySearchResults (p_context_id IN NUMBER) is
83: SELECT hzp.party_name, hzp.party_number,ca.account_number,
84: ARH_ADDR_PKG.FORMAT_ADDRESS(LOC.ADDRESS_STYLE,LOC.ADDRESS1,
85: LOC.ADDRESS2,LOC.ADDRESS3,LOC.ADDRESS4,LOC.CITY,LOC.COUNTY,
86: LOC.STATE,LOC.PROVINCE,LOC.POSTAL_CODE,
87: TERR.TERRITORY_SHORT_NAME ) CONCATENATED_ADDRESS
88: , score