APPS.IGS_TR_GEN_001 SQL Statements

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

Line: 25

        SELECT ts.action_days, ts.completion_dt, ts.by_pass_ind
        FROM   igs_tr_step ts
        WHERE  ts.tracking_id = cp_tracking_id
        AND    ts.tracking_step_number <= cp_tracking_step_number
        ORDER BY ts.tracking_step_number;

Line: 32

        SELECT ts.action_days
        FROM   igs_tr_step ts
        WHERE  ts.tracking_id = cp_tracking_id
        AND    ts.tracking_step_number = cp_tracking_step_number;

Line: 38

        SELECT NVL(override_offset_clc_ind , 'N'), completion_due_dt
        FROM   igs_tr_item
        WHERE  tracking_id = p_tracking_id ;

Line: 275

        SELECT  MAX(ts.completion_dt)
        FROM    igs_tr_step ts
        WHERE   ts.tracking_id = cp_tracking_id;