APPS.PRIMARY_CONTACTS_MGR SQL Statements

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

Line: 38

        SELECT FIRST_NAME, LAST_NAME, MIDDLE_NAME, PARTY_ID
        FROM   JTF_PARTY_CUSTOMERS_V
      --WHERE  LAST_NAME IS NOT NULL
        WHERE  PARTY_ID = P_PARTY_ID
      --AND    PARTY_ID < 9075
        ORDER BY 1;

Line: 126

        SELECT FIRST_NAME, LAST_NAME, MIDDLE_NAME, PARTY_ID
        FROM   JTF_PARTY_CUSTOMERS_V
      --WHERE  LAST_NAME IS NOT NULL
        WHERE  PARTY_ID = P_PARTY_ID
      --AND    PARTY_ID < 9075
        ORDER BY 1;