APPS.HR_HELPDESK_UTIL_SS SQL Statements

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

Line: 18

        select distinct person_id into pers_id
        from per_all_people_f
        where npw_number = cwk_id and
        business_group_id = bg_id and
        current_npw_flag='Y' and
        sysdate between effective_start_date and
        effective_end_date;

Line: 28

        select distinct person_id into pers_id
        from per_all_people_f
        where employee_number = emp_id and
        business_group_id = bg_id and
        current_employee_flag='Y' and
        sysdate between effective_start_date and
        effective_end_date;

Line: 55

     select distinct assignment_id into ass_id
     from per_all_assignments_f
     where person_id = pers_id
     and assignment_type in('E','A','C')
     and sysdate between effective_start_date and
     effective_end_date and
     primary_flag ='Y';

Line: 76

        select count(*) into per_sts from per_people_f
        where person_id = person_id and
        sysdate between effective_start_date and effective_end_date;

Line: 98

        select count(*) into ass_sts from per_assignments_f
        where assignment_id = assig_id and
        sysdate between effective_start_date and
        effective_end_date and
        primary_flag ='Y';

Line: 121

     select count(function_id) into l_count from (
     select fme.function_id,fme.menu_id from fnd_menu_entries fme
     start with fme.menu_id IN
     (select menu_id from fnd_responsibility where responsibility_id in(
     select responsibility_id from fnd_user_resp_groups
     where user_id = fnd_global.USER_ID))
     connect by fme.menu_id = prior fme.sub_menu_id )
     where function_id IN (select function_id from fnd_form_functions
     where function_name = 'HR_HELPDESK_SS') ;

Line: 149

     SELECT type INTO func_type FROM fnd_form_functions WHERE function_name = func_name;

Line: 170

   SELECT responsibility_key
   INTO l_resp_name
   FROM fnd_responsibility
   WHERE application_id = 800
   AND responsibility_id = resp_id;

Line: 191

   SELECT security_group_key
   INTO l_secgrp_key
   FROM fnd_security_groups
   WHERE security_group_id = sec_grp_id;