APPS.PRP_IH_EMAIL_PVT SQL Statements

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

Line: 60

  CURSOR c1 IS SELECT jtf_ih_media_items_s1.nextval FROM dual;

Line: 63

  SELECT HZP.PARTY_TYPE
    FROM HZ_PARTIES        HZP
   WHERE HZP.PARTY_ID = l_party_id;

Line: 68

  SELECT HZP.PARTY_ID,
         HZP.PARTY_TYPE
    FROM HZ_CONTACT_POINTS HCP,
         HZ_PARTIES        HZP
   WHERE HCP.OWNER_TABLE_NAME = 'HZ_PARTIES'
     AND HZP.PARTY_ID = HCP.OWNER_TABLE_ID
     AND HCP.CONTACT_POINT_TYPE = 'EMAIL'
     AND HCP.CONTACT_POINT_ID = l_contact_point_id;

Line: 78

  SELECT HPR.PARTY_ID
    FROM HZ_PARTIES             HZP,
         HZ_RELATIONSHIPS HPR
   WHERE HZP.PARTY_ID = HPR.PARTY_ID
     AND HPR.SUBJECT_ID = l_party_id;

Line: 85

  SELECT HPR.SUBJECT_ID
    FROM HZ_PARTIES             HZP,
         HZ_RELATIONSHIPS HPR
   WHERE HZP.PARTY_ID = HPR.SUBJECT_ID
     AND HPR.PARTY_ID = l_party_id
     AND HPR.OBJECT_ID = l_object_id;