APPS.OKL_IN_TPP_PVT SQL Statements

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

Line: 18

 SELECT  prt.PARTY_NAME,
 prt.ADDRESS1,
 prt.ADDRESS2,
 prt.ADDRESS3,
 prt.ADDRESS4,
 prt.CITY,
 prt.COUNTY,
 prt.PROVINCE,
 prt.STATE,
 prt.POSTAL_CODE,
 prt.COUNTRY
 FROM HZ_PARTIES prt ,HZ_PARTY_SITES hps
 WHERE prt.CATEGORY_CODE = 'INSURER' AND
       prt.PARTY_ID = hps.PARTY_ID AND
       --prt.THIRD_PARTY_FLAG ='Y' AND
       prt.PARTY_ID = p_isu_id AND
       hps.party_site_id = p_agency_site_id;

Line: 69

 SELECT prt.PARTY_NAME,
 prt.ADDRESS1,
 prt.ADDRESS2,
 prt.ADDRESS3,
 prt.ADDRESS4,
 prt.CITY,
 prt.COUNTY,
 prt.PROVINCE,
 prt.STATE,
 prt.POSTAL_CODE,
 prt.COUNTRY
 FROM HZ_PARTIES prt ,HZ_PARTY_SITES hps
 WHERE prt.CATEGORY_CODE = 'INSURANCE_AGENT' AND
       prt.PARTY_ID = hps.PARTY_ID AND
       --prt.THIRD_PARTY_FLAG ='Y' AND
       prt.PARTY_ID = p_int_id AND
       hps.party_site_id = p_agent_site_id;