APPS.PER_GET_ELIG SQL Statements

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

Line: 45

    OPEN c_per_asg FOR ' SELECT assignment_id,'||
                              ' business_group_id'||
                       ' FROM per_all_assignments_f'||
                       ' WHERE person_id = :1'||
                       ' AND assignment_id = NVL(:2, assignment_id)'||
                       ' AND effective_start_date <= :3'||
                       ' AND effective_end_date >= :4'
                 USING p_person_id
                     , p_assignment_id
                     , p_effective_date
                     , p_effective_date;

Line: 67

      OPEN c_elig_obj FOR ' SELECT elig_obj_id,'||
                                 ' effective_start_date,'||
                                 ' effective_end_date,'||
                                 ' column_name,'||
                                 ' column_value'||
                          ' FROM ben_elig_obj_f'||
                          ' WHERE table_name = :1'||
                          ' AND effective_start_date <= :2'||
                          ' AND effective_end_date >= :3'||
                          ' AND business_group_id = :4'
                    USING p_table_name
                        , p_effective_date
                        , p_effective_date
                        , l_business_group_id;

Line: 161

      SELECT OBJ.elig_obj_id
            ,OBJ.table_name
            ,OBJ.column_name
            ,OBJ.column_value
            ,OBJ.effective_start_date
            ,OBJ.effective_end_date
      FROM ben_elig_rslt_f RSLT
          ,ben_elig_obj_f  OBJ
      WHERE RSLT.person_id = cp_person_id
      AND RSLT.assignment_id = NVL(cp_assignment_id, RSLT.assignment_id)
      AND RSLT.effective_start_date <= cp_effective_date
      AND RSLT.effective_end_date >= cp_effective_date
      AND RSLT.elig_flag = 'Y'
      AND RSLT.elig_obj_id = OBJ.elig_obj_id
      AND OBJ.effective_start_date <= cp_effective_date
      AND OBJ.effective_end_date >= cp_effective_date;

Line: 257

      SELECT elig_obj_id
      FROM   ben_elig_obj_f
      WHERE  table_name = cp_table_name
      AND    column_name = cp_column_name
      AND    column_value = cp_column_value
      AND    business_group_id = cp_business_group_id
      AND    effective_start_date <= cp_effective_date
      AND    effective_end_date >= cp_effective_date;

Line: 291

    OPEN c_per FOR ' SELECT person_id,'||
                          ' party_id'||
                   ' FROM per_all_people_f'||
                   ' WHERE business_group_id = :1'||
                   ' AND effective_start_date <= :2'||
                   ' AND effective_end_date >= :3'
               USING p_business_group_id
                   , p_effective_date
                   , p_effective_date;

Line: 311

      OPEN c_asg FOR ' SELECT assignment_id,'||
                            ' effective_start_date,'||
                            ' effective_end_date'||
                     ' FROM per_all_assignments_f'||
                     ' WHERE person_id = :1'||
                     ' AND business_group_id = :2'||
                     ' AND effective_start_date <= :3'||
                     ' AND effective_end_date >= :4'
                 USING l_person_id
                     , p_business_group_id
                     , p_effective_date
                     , p_effective_date;

Line: 401

      SELECT RSLT.person_id
            ,RSLT.assignment_id
      FROM ben_elig_rslt_f RSLT
          ,ben_elig_obj_f  OBJ
      WHERE OBJ.table_name = cp_table_name
      AND   OBJ.column_name = cp_column_name
      AND   OBJ.column_value = cp_column_value
      AND   OBJ.effective_start_date <= cp_effective_date
      AND   OBJ.effective_end_date >= cp_effective_date
      AND   OBJ.elig_obj_id = RSLT.elig_obj_id
      AND   RSLT.effective_start_date <= cp_effective_date
      AND   RSLT.effective_end_date >= cp_effective_date
      AND   RSLT.business_group_id = cp_business_group_id
      AND   RSLT.elig_flag = 'Y';

Line: 420

      SELECT party_id
      FROM   per_all_people_f
      WHERE  person_id = cp_person_id
      AND    effective_start_date <= cp_effective_date
      AND    effective_end_date >= cp_effective_date;

Line: 431

      SELECT effective_start_date
            ,effective_end_date
      FROM   per_all_assignments_f
      WHERE  person_id = cp_person_id
      AND    assignment_id = cp_assignment_id
      AND    effective_start_date <= cp_effective_date
      AND    effective_end_date >= cp_effective_date;

Line: 657

      SELECT schedule_category
            ,schedule_name
      FROM   cac_sr_schedules_vl
      WHERE  schedule_id = cp_schedule_id
      AND    start_date_active = cp_start_date
      AND    end_date_active = cp_end_date;

Line: 752

      SELECT schedule_id
      FROM   cac_sr_schedules_vl
      WHERE  schedule_category = cp_schedule_category
      AND    schedule_name = cp_schedule_name
      AND    start_date_active <= cp_effective_date
      AND    end_date_active >= cp_effective_date;