APPS.PER_US_ASG_EXT_INFO_CHK SQL Statements

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

Line: 25

                  update_assignment_extra_info APIs.

    Change List
    -----------
    Date        Name       Vers    Bug No   Description
    ----------- ---------- ------  -------  -------------------------------
    26-MAY-2004 sdahiya    115.0            Created.
  *****************************************************************************/


/*******************************************************************************
    Name    : chk_dup_proration_ins
    Purpose : This procedure checks for unique combination of state and involuntary
              deduction category while inserting assignment EIT records.
*******************************************************************************/

PROCEDURE CHK_DUP_PRORATION_INS(
    p_assignment_id per_assignment_extra_info.assignment_id%TYPE,
    p_aei_information_category per_assignment_extra_info.aei_information_category%TYPE,
    p_aei_information1 per_assignment_extra_info.aei_information1%TYPE,
    p_aei_information2 per_assignment_extra_info.aei_information2%TYPE
    ) IS

    CURSOR c_dup_records IS
        SELECT COUNT(1)
          FROM per_assignment_extra_info
         WHERE assignment_id = p_assignment_id
           AND aei_information1 = p_aei_information1
           AND aei_information2 = p_aei_information2
           AND ((assignment_extra_info_id <> GLB_ASG_EXTRA_INFO_ID AND GLB_MODE IS NOT NULL) OR
                (GLB_MODE IS NULL))
           AND aei_information_category = 'US_PRORATION_RULE';

Line: 103

        SELECT assignment_id
          FROM per_assignment_extra_info
         WHERE assignment_extra_info_id = p_assignment_extra_info_id;

Line: 122

    GLB_MODE := 'UPDATE';