APPS.AS_ISSUE_UTIL_PVT SQL Statements

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

Line: 30

    SELECT  1
    FROM  HZ_PARTIES
    WHERE party_id = x_party_id;

Line: 103

        SELECT 'X'
        FROM  FND_LOOKUP_VALUES
        WHERE LOOKUP_TYPE = c_lookup_type
        AND  LOOKUP_CODE = c_contact_role_code;

Line: 166

        SELECT 'X'
        FROM  FND_LOOKUP_VALUES
        WHERE LOOKUP_TYPE = c_lookup_type
        AND  LOOKUP_CODE = c_strategy;

Line: 229

        SELECT 'X'
        FROM  FND_LOOKUP_VALUES
        WHERE LOOKUP_TYPE = c_lookup_type
        AND  LOOKUP_CODE = c_scheme;

Line: 291

        SELECT 'X'
        FROM  FND_LOOKUP_VALUES
        WHERE LOOKUP_TYPE = c_lookup_type
        AND  LOOKUP_CODE = c_issue_type;

Line: 367

        SELECT 'X'
        FROM  AS_ISSUE_GROUP_TYPES
        WHERE ISSUE_GROUP_TYPE_CODE = c_issue_group_type_code;

Line: 442

        SELECT 'X'
        FROM  FND_LOOKUP_VALUES
        WHERE LOOKUP_TYPE = c_lookup_type
        AND  LOOKUP_CODE = c_issue_relationship_type;

Line: 517

    SELECT 'X'
    FROM   fnd_territories_vl
    WHERE  territory_code = X_Country_Code;

Line: 587

    SELECT 'X'
    FROM   fnd_currencies_vl
    WHERE  currency_code = x_currency_code;