APPS.IGS_EN_VAL_PIG SQL Statements

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

Line: 29

  CURSOR cur_pig IS SELECT DISTINCT group_id
                    FROM igs_pe_prsid_grp_mem
                    WHERE person_id = p_person_id AND
		          TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date,TRUNC(SYSDATE));

Line: 34

                  IS SELECT prsid_max_cp,prsid_min_cp FROM igs_en_pig_cp_setup
                                                      WHERE group_id = cp_group_id;

Line: 106

  CURSOR cur_pig IS SELECT DISTINCT group_id
                    FROM igs_pe_prsid_grp_mem
                    WHERE person_id = p_person_id AND
		          TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date,TRUNC(SYSDATE));

Line: 111

                  IS SELECT s_enrolment_step_type,notification_flag FROM igs_en_pig_s_setup
                                     WHERE group_id = p_group_id;