APPS.IMC_BOOKMARK_PUB SQL Statements

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

Line: 22

  SELECT party_type
  INTO l_category
  FROM hz_parties
  WHERE party_id = p_bookmarked_party_id;

Line: 62

  SELECT party_name, party_type
  INTO l_party_name, l_category
  FROM hz_parties
  WHERE party_id = p_bookmarked_party_id;

Line: 80

  SELECT count(*)
  INTO l_bookmark_num
  FROM HZ_PARTY_PREFERENCES
  WHERE   MODULE = G_MODLUE
  AND     CATEGORY = l_category
  AND     PREFERENCE_CODE = G_PREFERENCE_CODE
  AND     PARTY_ID = p_party_id;

Line: 166

  SELECT user_name, email_address, customer_id, employee_id
  INTO l_user_name, l_email_address, l_party_id, l_person_id
  FROM fnd_user
  WHERE user_id = p_fnd_user_id;

Line: 193

    fnd_user_pkg.updateuser(x_user_name=>l_user_name,
			    x_owner=>'SEED',
			    x_customer_id=>l_party_id);

Line: 283

      select customer_id into l_user_id
      from fnd_user
      where user_id = p_party_id;

Line: 351

  SELECT party_id
  INTO l_party_id
  FROM hz_parties
  WHERE party_id = p_party_id;

Line: 361

        SELECT  value_number
        FROM    HZ_PARTY_PREFERENCES
        WHERE   MODULE = G_MODLUE
        AND     CATEGORY = p_bookmarked_party_type
        AND     PREFERENCE_CODE = G_PREFERENCE_CODE
        AND     PARTY_ID = p_party_id;

Line: 382

      SELECT  value_number
      FROM    HZ_PARTY_PREFERENCES
      WHERE   MODULE = G_MODLUE
      AND     PREFERENCE_CODE = G_PREFERENCE_CODE
      AND     PARTY_ID = p_party_id;

Line: 438

    select customer_id into l_user_id
    from fnd_user
    where user_id = p_party_id;

Line: 473

  select count(*) into l_count
  from hz_relationships
  where party_id = p_party_id
  and subject_type = 'ORGANIZATION'
  and object_type = 'ORGANIZATION';

Line: 526

    SELECT per.person_id,
           per.first_name,
           per.last_name,
           per.email_address
    FROM   per_all_people_f per
    WHERE  per.person_id = l_per_person_id
    AND    TRUNC(SYSDATE) BETWEEN effective_start_date
                          AND     effective_end_date;

Line: 570

      select hz_party_number_s.nextval into par_rec.party_number from dual;