APPS.HR_ACCRUAL_PLAN_TL SQL Statements

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

Line: 8

    INSERT
    INTO    pay_accrual_plans_tl
            (accrual_plan_id
            ,language
            ,source_lang
            ,accrual_plan_name
            ,description)
    SELECT  p_accrual_plan_id
           ,l.language_code
           ,userenv ('LANG')
           ,p_accrual_plan_name
           ,p_description
    FROM    fnd_languages l
    WHERE   l.installed_flag IN ('I','B')
    AND     NOT EXISTS
                (
                SELECT  NULL
                FROM    pay_accrual_plans_tl t
                WHERE   t.accrual_plan_id = p_accrual_plan_id
                AND     t.language = l.language_code
                );

Line: 35

    UPDATE  pay_accrual_plans_tl
    SET     description = p_description
           ,source_lang = userenv ('LANG')
    WHERE   accrual_plan_id = p_accrual_plan_id
    AND     userenv ('LANG') IN (language,source_lang);

Line: 45

    DELETE
    FROM    pay_accrual_plans_tl
    WHERE   accrual_plan_id = p_accrual_plan_id;

Line: 52

    DELETE
    FROM    pay_accrual_plans_tl t
    WHERE   NOT EXISTS
                (
                SELECT  NULL
                FROM    pay_accrual_plans b
                WHERE   b.accrual_plan_id = t.accrual_plan_id
                );

Line: 61

    UPDATE  pay_accrual_plans_tl t
    SET     (accrual_plan_name
             ,description) =
                             (
                             SELECT  b.accrual_plan_name
                                    ,b.description
                             FROM    pay_accrual_plans_tl b
                             WHERE   b.accrual_plan_id = t.accrual_plan_id
                             AND     b.language = t.source_lang
                             )
    WHERE   (t.accrual_plan_id,t.language) IN
            (
            SELECT  subt.accrual_plan_id
                   ,subt.language
            FROM    pay_accrual_plans_tl subb
                   ,pay_accrual_plans_tl subt
            WHERE   subb.accrual_plan_id = subt.accrual_plan_id
            AND     subb.language = subt.source_lang
            AND     (
                            subb.accrual_plan_name <> subt.accrual_plan_name
                    OR      subb.description <> subt.description
                    OR      (
                                    subb.description IS NULL
                            AND     subt.description IS NOT NULL
                            )
                    OR      (
                                    subb.description IS NOT NULL
                            AND     subt.description IS NULL
                            )
                    )
            );

Line: 93

    INSERT
    INTO    pay_accrual_plans_tl
            (accrual_plan_id
            ,accrual_plan_name
            ,description
            ,language
            ,source_lang)
    SELECT  b.accrual_plan_id
           ,b.accrual_plan_name
           ,b.description
           ,l.language_code
           ,b.source_lang
    FROM    pay_accrual_plans_tl b
           ,fnd_languages l
    WHERE   l.installed_flag IN ('I','B')
    AND     b.language = userenv ('LANG')
    AND     NOT EXISTS
                (
                SELECT  NULL
                FROM    pay_accrual_plans_tl t
                WHERE   t.accrual_plan_id = b.accrual_plan_id
                AND     t.language = l.language_code
                );

Line: 126

      SELECT  'Y'
      FROM    pay_accrual_plans
      WHERE   accrual_plan_name = p_accrual_plan_name
      AND     business_group_id = p_business_group_id
      AND     (
                      p_accrual_plan_id IS NULL
              OR      p_accrual_plan_id <> accrual_plan_id
              );

Line: 137

      SELECT  'Y'
      FROM    pay_accrual_plans
      WHERE   business_group_id = p_business_group_id
      AND     accrual_plan_id =
              (
              SELECT  DISTINCT
                      accrual_plan_id
              FROM    pay_accrual_plans_tl
              WHERE   accrual_plan_name = p_accrual_plan_name
              AND     (
                              p_accrual_plan_id IS NULL
                      OR      p_accrual_plan_id <> accrual_plan_id
                      )
              );