APPS.AR_CMGT_PARTY_SEARCH SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 83

        SELECT hzp.party_name, hzp.party_number,ca.account_number,
               ARH_ADDR_PKG.FORMAT_ADDRESS(LOC.ADDRESS_STYLE,LOC.ADDRESS1,
                    LOC.ADDRESS2,LOC.ADDRESS3,LOC.ADDRESS4,LOC.CITY,LOC.COUNTY,
                    LOC.STATE,LOC.PROVINCE,LOC.POSTAL_CODE,
                    TERR.TERRITORY_SHORT_NAME ) CONCATENATED_ADDRESS
               , score
        FROM HZ_MATCHED_PARTIES_GT GT,
             HZ_PARTIES HZP,
             HZ_CUST_ACCOUNTS CA,
             HZ_CUST_ACCT_SITES CAS,
             HZ_LOCATIONS LOC,
             HZ_PARTY_SITES PARTY_SITE,
             FND_TERRITORIES_VL TERR
        WHERE SEARCH_CONTEXT_ID = p_context_id
          AND GT.PARTY_ID = HZP.PARTY_ID
          AND GT.PARTY_ID = CA.PARTY_ID(+)
          AND CAS.CUST_ACCOUNT_ID(+) = CA.CUST_ACCOUNT_ID
          AND CAS.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID(+)
          AND LOC.LOCATION_ID(+) = PARTY_SITE.LOCATION_ID
          AND LOC.COUNTRY   = TERR.TERRITORY_CODE(+);

Line: 105

          SELECT match_rule_id
	  FROM hz_match_rules_vl
	  where RULE_NAME ='HZ_ORG_SIMPLE_SEARCH_RULE';