APPS.IGS_AD_IMP_023 SQL Statements

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

Line: 27

       SELECT discrepancy_rule_cd
       FROM   igs_ad_dscp_attr
       WHERE  UPPER(attribute_name) = UPPER(p_attribute_name)
       AND    src_cat_id =    (SELECT src_cat_id
                               FROM   igs_ad_source_cat
                               WHERE  source_type_id = p_source_type_id
                               AND    category_name  = p_category);

Line: 78

       SELECT discrepancy_rule_cd
       FROM   igs_ad_dscp_attr
       WHERE  UPPER(attribute_name) = UPPER(p_attribute_name)
       AND    src_cat_id =    (SELECT src_cat_id
                               FROM   igs_ad_source_cat
                               WHERE  source_type_id = p_source_type_id
                               AND    category_name  = p_category);

Line: 129

       SELECT discrepancy_rule_cd
       FROM   igs_ad_dscp_attr
       WHERE  UPPER(attribute_name) = UPPER(p_attribute_name)
       AND    src_cat_id =    (SELECT src_cat_id
                               FROM   igs_ad_source_cat
                               WHERE  source_type_id = p_source_type_id
                               AND    category_name  = p_category);

Line: 250

       SELECT *
       FROM   igs_ad_source_cat
       WHERE  source_type_id = p_source_type_id
       AND    category_name  = p_category;

Line: 259

       SELECT *
       FROM   igs_ad_dscp_attr
       WHERE  src_cat_id = cp_src_cat_id
       AND    NVL(discrepancy_rule_cd,'I') = 'R';

Line: 280

         ** ' SELECT 1
         **   FROM   IGS_PE_PERSON
         **   WHERE  PERSON_ID = 9855582
         **   AND    BIRTH_DT  =   SELECT  BIRTH_DT
         **                        FROM   IGS_AD_INTERFACE_DTL_DSCP_V
         **                        WHERE  INTERFACE_ID = 55 ) '
         */
                   --Dynamic SQL  statements are declared for both Admission and Interface columns to check for NULL values.
             l_admission_sql:='SELECT 1 FROM ' ||source_cat_rec.ad_tab_name
                                    ||' WHERE  ' || p_ad_pk_col_name || '= :cp_ad_pk_col_value AND '
                                    || detail_discrepancy_rec.attribute_name
                                    ||' IS NULL';

Line: 293

             l_interface_sql :='SELECT 1 FROM ' ||source_cat_rec.int_tab_name
                                    ||' WHERE  ' || p_int_pk_col_name || '= :cp_int_pk_col_value AND '
                                    || detail_discrepancy_rec.attribute_name
                                    ||' IS NULL';

Line: 312

		  -- Discrepancy exists, match indicator for this record should be updated to '20'.
          IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

            l_label := l_label || 'discpNULL';

Line: 324

         l_ref_cur_sql := ' SELECT 1 FROM   ' || source_cat_rec.ad_tab_name
           || ' WHERE  ' || p_ad_pk_col_name || '= :cp_ad_pk_col_value AND '
           || detail_discrepancy_rec.attribute_name
           || ' = ' || '  ( SELECT ' || detail_discrepancy_rec.attribute_name
           || ' FROM   ' || source_cat_rec.int_tab_name
           || ' WHERE  ' || p_int_pk_col_name || '= :cp_int_pk_col_value )' ;

Line: 399

       SELECT count(ROWID)
       FROM   igs_ad_dscp_attr
       WHERE  src_cat_id = (SELECT src_cat_id
                            FROM   igs_ad_source_cat
                            WHERE  category_name = p_category
                            AND    source_type_id = p_Source_type_id)
       AND    NVL(discrepancy_rule_cd,'E') = 'R';

Line: 409

       SELECT count(ROWID)
       FROM   igs_ad_dscp_attr
       WHERE  src_cat_id = (SELECT src_cat_id
                            FROM   igs_ad_source_cat
                            WHERE  category_name = p_category
                            AND    source_type_id = p_Source_type_id)
       AND    NVL(discrepancy_rule_cd,'E') = 'I';