APPS.IGS_TR_VAL_TRST SQL Statements

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

Line: 30

        SELECT sequence_ind , override_offset_clc_ind
        FROM   igs_tr_item
        WHERE  tracking_id = cp_tracking_id;

Line: 38

        SELECT  distinct to_number('1')
        FROM    igs_tr_step trst
        WHERE   trst.tracking_id = cp_tracking_id
        AND     trst.tracking_step_number < cp_tracking_step_number
        AND     trst.step_group_id is null
        AND     trst.step_completion_ind = 'N'
        AND     trst.by_pass_ind = 'N'
    UNION
      (SELECT distinct trst.step_group_id
       FROM   igs_tr_step  trst
       WHERE  trst.tracking_id = cp_tracking_id
       AND     trst.tracking_step_number < cp_tracking_step_number
       AND     trst.step_group_id is not null
       AND     trst.step_completion_ind = 'N'
       AND     trst.by_pass_ind = 'N'
       GROUP BY  trst.step_group_id , trst.step_completion_ind
       MINUS
       SELECT distinct trst.step_group_id
       FROM   igs_tr_step  trst
       WHERE  trst.tracking_id = cp_tracking_id
       AND     trst.tracking_step_number < cp_tracking_step_number
       AND     trst.step_group_id is not null
       AND     trst.step_completion_ind = 'Y'
       GROUP BY  trst.step_group_id , trst.step_completion_ind
      );

Line: 69

        SELECT  distinct to_number('1')
        FROM    igs_tr_step trst
        WHERE   trst.tracking_id = cp_tracking_id
    AND     trst.tracking_step_number > cp_tracking_step_number
    AND     trst.step_group_id is null
    AND     trst.step_completion_ind = 'Y'
    MINUS
    SELECT  distinct to_number('1')
        FROM    igs_tr_step trst
        WHERE   trst.tracking_id = cp_tracking_id
    AND     trst.tracking_step_number = cp_tracking_step_number
    AND     trst.step_group_id is not null
    AND     trst.step_completion_ind = 'N'
    UNION
      (SELECT distinct trst.step_group_id
       FROM   igs_tr_step  trst
       WHERE  trst.tracking_id = cp_tracking_id
       AND     trst.tracking_step_number > cp_tracking_step_number
       AND     trst.step_group_id is not null
       AND     trst.step_completion_ind = 'Y'
       GROUP BY  trst.step_group_id , trst.step_completion_ind
       MINUS
       SELECT distinct trst.step_group_id
       FROM   igs_tr_step  trst
       WHERE  trst.tracking_id = cp_tracking_id
       AND     trst.tracking_step_number < cp_tracking_step_number
       AND     trst.step_group_id is not null
       GROUP BY  trst.step_group_id , trst.step_completion_ind
      );

Line: 214

   SELECT s_tracking_type
   FROM   igs_tr_type
   WHERE  tracking_type = p_tracking_type;

Line: 219

   SELECT 'X'
   FROM   igs_lookup_values
   WHERE  lookup_type = p_s_tracking_step_type AND
          lookup_code = cp_s_tracking_type;