APPS.HR_MX_EXTRA_ASG_RULES SQL Statements

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

Line: 33

     SELECT paf.location_id,
            hsck.segment1
       FROM per_assignments_f      PAF,
            hr_soft_coding_keyflex HSCK
      WHERE paf.assignment_id = p_assignment_id
        AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
        AND trunc(p_effective_date) BETWEEN paf.effective_start_date
                                        AND paf.effective_end_date;

Line: 84

                                       p_datetrack_update_mode IN VARCHAR2,
                                      p_assignment_id         IN per_assignments_f.assignment_id%TYPE,
                                      p_location_id           IN hr_locations.location_id%TYPE,
                                      p_scl_segment1          IN hr_soft_coding_keyflex.segment1%TYPE
                                     ) AS
--
        l_gre_old       hr_soft_coding_keyflex.segment1%TYPE;

Line: 105

        SELECT business_group_id
          FROM per_assignments_f
         WHERE assignment_id = p_assignment_id
           AND rownum < 2;

Line: 169

        SELECT decode(p_scl_segment1, hr_api.g_varchar2, l_scl_gre, p_scl_segment1),
               decode(p_location_id, hr_api.g_number, l_location_old, p_location_id)
        INTO   l_segment1,
               l_location_id
        FROM DUAL;

Line: 202

           p_datetrack_update_mode IN ('UPDATE', 'UPDATE_CHANGE_INSERT', 'UPDATE_OVERRIDE') THEN

--------------------------------------------------------------------------
-- If YES, then check the leaving reason Global Variable. If it's null,
-- raise an error. Else, insert an Assignment EIT record using the API.
--------------------------------------------------------------------------
                IF hr_mx_assignment_api.g_leaving_reason IS NULL THEN

--                        hr_utility.set_message(800,'HR_MX_MISSING_LEAVING_REASON');

Line: 272

                                  p_datetrack_update_mode IN VARCHAR2,
                                  p_assignment_id         IN per_assignments_f.assignment_id%TYPE,
                                  p_segment1              IN hr_soft_coding_keyflex.segment1%TYPE
                                 ) AS
--
        l_gre_old       hr_soft_coding_keyflex.segment1%TYPE;

Line: 290

        SELECT business_group_id
          FROM per_assignments_f
         WHERE assignment_id = p_assignment_id
           AND rownum < 2;

Line: 355

        SELECT decode(p_segment1, hr_api.g_varchar2, l_scl_gre, p_segment1)
        INTO   l_segment1
        FROM DUAL;

Line: 383

           p_datetrack_update_mode IN ('UPDATE', 'UPDATE_CHANGE_INSERT', 'UPDATE_OVERRIDE') THEN

--------------------------------------------------------------------------
-- If YES, then check the leaving reason Global Variable. If it's null,
-- raise an error. Else, insert an Assignment EIT record using the API.
--------------------------------------------------------------------------
                IF hr_mx_assignment_api.g_leaving_reason IS NULL THEN

                        IF g_debug THEN
                                hr_utility.set_location(l_proc, 40);

Line: 467

        SELECT business_group_id
          FROM per_assignments_f
         WHERE assignment_id = p_assignment_id
           AND rownum < 2;

Line: 647

                  SELECT TRUNC(effective_date)
                    INTO ld_effective_date
                    FROM fnd_sessions
                   WHERE session_id = userenv('sessionid');

Line: 658

                hr_periods_of_service_api.update_pds_details
                   (p_effective_date           => ld_effective_date
                   ,p_final_process_date       => trunc(p_final_process_date)
                   ,p_period_of_service_id     => p_period_of_service_id
                   ,p_pds_information_category => 'MX'
                   ,p_pds_information1         =>
                                         hr_mx_assignment_api.g_leaving_reason
                   ,p_object_version_number    => l_dummy
                      );