how to use like for variable in pl sql

SELECT hc.account_number
     , hp.party_name
     , location_id
     , acct_site.cust_acct_site_id
     ,    hpsv.address1
       || hpsv.address2
       || hpsv.address3
       || hpsv.address4 address
     , hpsv.city
     , hpsv.state
     , hpsv.postal_code
  FROM hz_cust_site_uses_all site
     , apps.hz_cust_accounts_all hc
     , hz_parties hp
     , hz_cust_acct_sites_all acct_site
     , apps.hz_party_sites_v hpsv
 WHERE site.site_use_code = 'BILL_TO'
   AND hpsv.site_use_type = site.site_use_code
   AND site.cust_acct_site_id = acct_site.cust_acct_site_id
   AND hc.party_id = hp.party_id
   AND site.org_id = acct_site.org_id
   AND acct_site.party_site_id = hpsv.party_site_id
   AND hpsv.party_id = hp.party_id
   AND site.primary_flag = 'Y'
   AND hc.cust_account_id = acct_site.cust_account_id
   AND hc.status = 'A'
   AND acct_site.status = 'A'
   AND site.status = 'A'
   AND hpsv.status = 'A'
   AND UPPER (hp.party_name) LIKE    '%' || UPPER (p_party_name) || '%'
   AND UPPER (hpsv.address1) LIKE    '%' || UPPER (p_party_address) || '%'
   AND UPPER (hpsv.city) = UPPER (p_city)
   AND UPPER (hpsv.state) = UPPER (p_state)
   AND hpsv.postal_code = p_postal_code

how to find LOV query in oracle apps form

Step 1: Find the form name (.fmb name). (Help --> About Oracle Applications)
Step 2: click on List of values and enter the filter condition and click Find button.
Step 3: Keep the screen in the above state.
Step 4: Connect to database and run the below SQL Statement.

SELECT (SELECT TO_CHAR (sql_fulltext)
          FROM v$sqlarea
         WHERE sql_id = ses.prev_sql_id)
  FROM v$session ses
     , v$sqlarea sq
 WHERE upper(ses.module) LIKE upper('%FORM_NAME%')
   AND upper(client_identifier) = upper('USER_NAME')
   AND sq.sql_id(+) = ses.sql_id;