APPS.BEN_CWB_WF_NTF SQL Statements

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

Line: 14

       SELECT attribute40
         FROM ben_transaction
        WHERE transaction_type = 'BDGTNTF'
          AND transaction_id = to_number(v_transaction_id);

Line: 44

       SELECT attribute40
         FROM ben_transaction
        WHERE transaction_type = 'APPRNTF'
          AND transaction_id = to_number(v_transaction_id);

Line: 74

       SELECT attribute40
         FROM ben_transaction
        WHERE transaction_id = to_number(v_transaction_id);

Line: 120

         SELECT dsgn.NAME
           FROM ben_per_in_ler pil, ben_cwb_pl_dsgn dsgn
          WHERE pil.per_in_ler_id = p_group_per_in_ler_id
            AND pil.group_pl_id = dsgn.pl_id
            AND pil.lf_evt_ocrd_dt = dsgn.lf_evt_ocrd_dt
            AND dsgn.group_pl_id = dsgn.pl_id
            AND dsgn.group_oipl_id = -1;

Line: 145

         SELECT per.full_name
           FROM ben_per_in_ler pil,
                per_all_people_f per
          WHERE pil.per_in_ler_id = p_group_per_in_ler_id
            AND pil.ws_mgr_id = per.person_id
            AND sysdate between per.effective_start_date and per.effective_end_date;

Line: 167

         SELECT info.full_name, info.brief_name
           FROM ben_cwb_person_info info
          WHERE info.group_per_in_ler_id = p_group_per_in_ler_id;

Line: 196

         SELECT nvl(dsgn.wthn_yr_start_dt,dsgn.yr_perd_start_dt)||' - '||
         nvl(dsgn.wthn_yr_end_dt,dsgn.yr_perd_end_dt) forPeriod
           FROM ben_per_in_ler pil,
                ben_cwb_pl_dsgn dsgn
          WHERE pil.per_in_ler_id = p_group_per_in_ler_id
            AND pil.group_pl_id = dsgn.group_pl_id
            AND pil.lf_evt_ocrd_dt = dsgn.lf_evt_ocrd_dt
            AND dsgn.oipl_id = -1
            AND dsgn.group_pl_id = dsgn.pl_id
            AND dsgn.group_oipl_id = dsgn.oipl_id;

Line: 264

         SELECT user_name
           FROM fnd_user
          WHERE employee_id = p_person_id;

Line: 328

      SELECT notification_id
        FROM wf_item_activity_statuses
       WHERE item_key = p_item_key
         AND item_type = g_itemtype
         AND assigned_user = p_fnd_user_name;

Line: 395

         SELECT n.status
           INTO l_status
           FROM wf_notifications n
          WHERE n.notification_id = l_notification_id;

Line: 590

      SELECT ben_cwb_wf_ntf_s.NEXTVAL
        INTO l_itemkey
        FROM DUAL;

Line: 777

         SELECT role_id, role_name
           FROM pqh_roles
          WHERE role_type_cd = 'CWB';

Line: 783

         SELECT pei.person_id person_id, ppf.full_name person_name,
                usr.user_name user_name, usr.user_id user_id
           FROM per_people_extra_info pei,
                per_all_people_f ppf,
                fnd_user usr,
                pqh_roles rls
          WHERE information_type = 'PQH_ROLE_USERS'
            AND pei.person_id = ppf.person_id
            AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date
                                    AND ppf.effective_end_date
            AND usr.employee_id = ppf.person_id
            AND rls.role_id = TO_NUMBER (pei.pei_information3)
            AND NVL (pei.pei_information5, 'Y') = 'Y'
            AND rls.role_id = l_role_id;