APPS.BEN_CAGR_CHECK_ELIGIBILITY SQL Statements

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

Line: 1132

    select dis.CATEGORY,
           dis.DEGREE,
           dis.REASON
    from per_disabilities_f dis
    where dis.person_id = c_per_id
    and c_eff_dt
      between dis.effective_start_date and dis.effective_end_date;

Line: 1147

    select qua.TITLE,
           qua.QUALIFICATION_TYPE_ID
    from per_qualifications qua
    where qua.person_id = c_per_id
    and c_eff_dt between nvl(start_date,hr_general.start_of_time)
                      and nvl(end_date,hr_general.end_of_time)
    order by nvl(start_date,hr_general.start_of_time) desc ,qualification_id desc ;

Line: 1163

    select role.job_group_id
    from per_roles role
    where role.person_id = c_per_id
    and   role.job_id = c_asg_job_id;