APPS.HR_WRK_SCH_PKG SQL Statements

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

Line: 42

      SELECT MAX(hier_seq)
      FROM   per_sch_inherit_hier
      WHERE  in_hier = 'Y'
      AND    hier_seq IS NOT NULL;

Line: 49

      SELECT inherit_level
      FROM   per_sch_inherit_hier
      WHERE  hier_seq = cp_inh_seq;

Line: 56

      SELECT business_group_id
            ,organization_id
            ,job_id
            ,position_id
            ,location_id
      FROM   per_all_assignments_f
      WHERE  assignment_id = cp_per_asg_id
      AND    cp_eff_date BETWEEN effective_start_date
                         ANd     effective_end_date;

Line: 73

      SELECT COUNT(*)
      FROM   cac_sr_schdl_objects CSSO
            ,cac_sr_schedules_b   CSSB
      WHERE  CSSO.object_type = cp_object_type
      AND    CSSO.object_id = cp_object_id
      AND    CSSO.start_date_active <= cp_end_date
      AND    CSSO.end_date_active >= cp_start_date
      AND    CSSO.schedule_id = CSSB.schedule_id
      AND    CSSB.deleted_date IS NULL
      AND    (CSSB.schedule_category = cp_sch_cat
              OR
              CSSB.schedule_id IN (SELECT schedule_id
                                   FROM   cac_sr_publish_schedules
                                   WHERE  object_type = cp_object_type
                                   AND    object_id = cp_object_id
                                   AND    cp_sch_cat IS NULL
                                  )
             );

Line: 98

      SELECT CSSO.start_date_active,CSSO.end_date_active
      FROM   cac_sr_schdl_objects CSSO
            ,cac_sr_schedules_b   CSSB
      WHERE  CSSO.object_type = cp_object_type
      AND    CSSO.object_id = cp_object_id
      AND    CSSO.start_date_active <= cp_end_date
      AND    CSSO.end_date_active >= cp_start_date
      AND    CSSO.schedule_id = CSSB.schedule_id
      AND    CSSB.deleted_date IS NULL
      AND    (CSSB.schedule_category = cp_sch_cat
              OR
              CSSB.schedule_id IN (SELECT schedule_id
                                   FROM   cac_sr_publish_schedules
                                   WHERE  object_type = cp_object_type
                                   AND    object_id = cp_object_id
                                   AND    cp_sch_cat IS NULL
                                  )
             );

Line: 474

      SELECT MAX(hier_seq)
      FROM   per_sch_inherit_hier
      WHERE  in_hier = 'Y'
      AND    hier_seq IS NOT NULL;

Line: 481

      SELECT inherit_level
      FROM   per_sch_inherit_hier
      WHERE  hier_seq = cp_inh_seq;

Line: 488

      SELECT business_group_id
            ,organization_id
            ,job_id
            ,position_id
            ,location_id
      FROM   per_all_assignments_f
      WHERE  assignment_id = cp_per_asg_id
      AND    cp_eff_date BETWEEN effective_start_date
                         ANd     effective_end_date;

Line: 505

      SELECT COUNT(*)
      FROM   cac_sr_schdl_objects CSSO
            ,cac_sr_schedules_b   CSSB
      WHERE  CSSO.object_type = cp_object_type
      AND    CSSO.object_id = cp_object_id
      AND    CSSO.start_date_active <= cp_end_date
      AND    CSSO.end_date_active >= cp_start_date
      AND    CSSO.schedule_id = CSSB.schedule_id
      AND    CSSB.deleted_date IS NULL
      AND    (CSSB.schedule_category = cp_sch_cat
              OR
              CSSB.schedule_id IN (SELECT schedule_id
                                   FROM   cac_sr_publish_schedules
                                   WHERE  object_type = cp_object_type
                                   AND    object_id = cp_object_id
                                   AND    cp_sch_cat IS NULL
                                  )
             );

Line: 532

      SELECT CSSO.start_date_active,CSSO.end_date_active
      FROM   cac_sr_schdl_objects CSSO
            ,cac_sr_schedules_b   CSSB
      WHERE  CSSO.object_type = cp_object_type
      AND    CSSO.object_id = cp_object_id
      AND    CSSO.start_date_active <= cp_end_date
      AND    CSSO.end_date_active >= cp_start_date
      AND    CSSO.schedule_id = CSSB.schedule_id
      AND    CSSB.deleted_date IS NULL
      AND    (CSSB.schedule_category = cp_sch_cat
              OR
              CSSB.schedule_id IN (SELECT schedule_id
                                   FROM   cac_sr_publish_schedules
                                   WHERE  object_type = cp_object_type
                                   AND    object_id = cp_object_id
                                   AND    cp_sch_cat IS NULL
                                  )
             );

Line: 571

    SELECT DECODE(p_include_exceptions, 'Y','T', 'N','F', 'T','T', 'F','F', 'T')
    INTO l_include_exceptions FROM DUAL;