APPS.PER_QAT_SHD SQL Statements

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

Line: 47

    select
       qualification_id
      ,language
      ,source_lang
      ,title
      ,group_ranking
      ,license_restrictions
      ,awarding_body
      ,grade_attained
      ,reimbursement_arrangements
      ,training_completed_units
      ,membership_category
    from  per_qualifications_tl
    where qualification_id = p_qualification_id
    and   language = p_language;

Line: 120

    select
       qualification_id
      ,language
      ,source_lang
      ,title
      ,group_ranking
      ,license_restrictions
      ,awarding_body
      ,grade_attained
      ,reimbursement_arrangements
      ,training_completed_units
      ,membership_category
    from        per_qualifications_tl
    where       qualification_id = p_qualification_id
    and   language = p_language
    for update nowait;

Line: 188

  delete from PER_QUALIFICATIONS_TL T
  where not exists
    (select NULL
    from PER_QUALIFICATIONS B
    where B.QUALIFICATION_ID = T.QUALIFICATION_ID
    );

Line: 195

  update PER_QUALIFICATIONS_TL T set (
      TITLE,
      GROUP_RANKING,
      LICENSE_RESTRICTIONS,
      AWARDING_BODY,
      GRADE_ATTAINED,
      REIMBURSEMENT_ARRANGEMENTS,
      TRAINING_COMPLETED_UNITS,
      MEMBERSHIP_CATEGORY
    ) = (select
      B.TITLE,
      B.GROUP_RANKING,
      B.LICENSE_RESTRICTIONS,
      B.AWARDING_BODY,
      B.GRADE_ATTAINED,
      B.REIMBURSEMENT_ARRANGEMENTS,
      B.TRAINING_COMPLETED_UNITS,
      B.MEMBERSHIP_CATEGORY
    from PER_QUALIFICATIONS_TL B
    where B.QUALIFICATION_ID = T.QUALIFICATION_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.QUALIFICATION_ID,
      T.LANGUAGE
  ) in (select
      SUBT.QUALIFICATION_ID,
      SUBT.LANGUAGE
    from PER_QUALIFICATIONS_TL SUBB, PER_QUALIFICATIONS_TL SUBT
    where SUBB.QUALIFICATION_ID = SUBT.QUALIFICATION_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.GROUP_RANKING <> SUBT.GROUP_RANKING
      or (SUBB.GROUP_RANKING is null and SUBT.GROUP_RANKING is not null)
      or (SUBB.GROUP_RANKING is not null and SUBT.GROUP_RANKING is null)
      or SUBB.TITLE <> SUBT.TITLE
      or (SUBB.TITLE is null and SUBT.TITLE is not null)
      or (SUBB.TITLE is not null and SUBT.TITLE is null)
      or SUBB.LICENSE_RESTRICTIONS <> SUBT.LICENSE_RESTRICTIONS
      or (SUBB.LICENSE_RESTRICTIONS is null and SUBT.LICENSE_RESTRICTIONS is not null)
      or (SUBB.LICENSE_RESTRICTIONS is not null and SUBT.LICENSE_RESTRICTIONS is null)
      or SUBB.AWARDING_BODY <> SUBT.AWARDING_BODY
      or (SUBB.AWARDING_BODY is null and SUBT.AWARDING_BODY is not null)
      or (SUBB.AWARDING_BODY is not null and SUBT.AWARDING_BODY is null)
      or SUBB.GRADE_ATTAINED <> SUBT.GRADE_ATTAINED
      or (SUBB.GRADE_ATTAINED is null and SUBT.GRADE_ATTAINED is not null)
      or (SUBB.GRADE_ATTAINED is not null and SUBT.GRADE_ATTAINED is null)
      or SUBB.REIMBURSEMENT_ARRANGEMENTS <> SUBT.REIMBURSEMENT_ARRANGEMENTS
      or (SUBB.REIMBURSEMENT_ARRANGEMENTS is null and SUBT.REIMBURSEMENT_ARRANGEMENTS is not null)
      or (SUBB.REIMBURSEMENT_ARRANGEMENTS is not null and SUBT.REIMBURSEMENT_ARRANGEMENTS is null)
      or SUBB.TRAINING_COMPLETED_UNITS <> SUBT.TRAINING_COMPLETED_UNITS
      or (SUBB.TRAINING_COMPLETED_UNITS is null and SUBT.TRAINING_COMPLETED_UNITS is not null)
      or (SUBB.TRAINING_COMPLETED_UNITS is not null and SUBT.TRAINING_COMPLETED_UNITS is null)
      or SUBB.MEMBERSHIP_CATEGORY <> SUBT.MEMBERSHIP_CATEGORY
      or (SUBB.MEMBERSHIP_CATEGORY is null and SUBT.MEMBERSHIP_CATEGORY is not null)
      or (SUBB.MEMBERSHIP_CATEGORY is not null and SUBT.MEMBERSHIP_CATEGORY is null)
  ));

Line: 251

  insert into PER_QUALIFICATIONS_TL (
    QUALIFICATION_ID,
    TITLE,
    GROUP_RANKING,
    LICENSE_RESTRICTIONS,
    AWARDING_BODY,
    GRADE_ATTAINED,
    REIMBURSEMENT_ARRANGEMENTS,
    TRAINING_COMPLETED_UNITS,
    MEMBERSHIP_CATEGORY,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.QUALIFICATION_ID,
    B.TITLE,
    B.GROUP_RANKING,
    B.LICENSE_RESTRICTIONS,
    B.AWARDING_BODY,
    B.GRADE_ATTAINED,
    B.REIMBURSEMENT_ARRANGEMENTS,
    B.TRAINING_COMPLETED_UNITS,
    B.MEMBERSHIP_CATEGORY,
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from PER_QUALIFICATIONS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from PER_QUALIFICATIONS_TL T
    where T.QUALIFICATION_ID = B.QUALIFICATION_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);