APPS.PQH_RBC_VALIDATE SQL Statements

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

Line: 7

   cursor c1 is select copy_entity_result_id from ben_copy_entity_results
                where copy_entity_txn_id = p_copy_entity_txn_id
                and table_alias = 'RBC_CRIT' and dml_operation <> 'DELETE';

Line: 25

   cursor c1 is select copy_entity_result_id from ben_copy_entity_results
                where copy_entity_txn_id = p_copy_entity_txn_id
                and table_alias = 'RMR' and dml_operation <> 'DELETE'
                and Information297 is not null
                and Information297 <> 0;

Line: 44

   cursor c1 is select copy_entity_result_id from ben_copy_entity_results
                where copy_entity_txn_id = p_copy_entity_txn_id
                and table_alias = 'RMV' and dml_operation <> 'DELETE';

Line: 66

   cursor c1 is select INFORMATION13,INFORMATION160  from ben_copy_entity_results
                where copy_entity_txn_id = p_copy_entity_txn_id
                and table_alias = 'RBC_CRIT' and dml_operation <> 'DELETE';

Line: 71

    is select copy_entity_result_id from ben_copy_entity_results
                where copy_entity_txn_id = p_copy_entity_txn_id
                and table_alias = 'RMN' and dml_operation <> 'DELETE'
                and INFORMATION13 = l_sh_code and INFORMATION160 =  l_level_num;

Line: 77

    is select name from ben_eligy_criteria
                where short_code = l_sh_code;

Line: 117

   cursor c1 is Select information1 from ben_copy_entity_results
            Where copy_entity_txn_id = p_copy_entity_txn_id and table_alias = 'RCR';

Line: 134

   cursor c1 is select count(information13) from ben_copy_entity_results
               where table_alias = 'RBC_CRIT' and dml_operation <> 'DELETE' and copy_entity_txn_id = p_copy_entity_txn_id
               group by information13;

Line: 154

   cursor c1 is select name from ben_pl_f
               where name = p_name
               and pl_id <> l_pl_id
               and business_group_id = p_business_group_id;

Line: 178

   cursor c1 is select short_code from ben_pl_f
               where short_code = p_short_code
               and pl_id <> l_pl_id
               and business_group_id = p_business_group_id;

Line: 200

   cursor c1 is select short_name from ben_pl_f
               where short_name = p_short_name
               and pl_id <> l_pl_id
               and business_group_id = p_business_group_id;

Line: 229

    cursor c1 is select information1,information170, information93, information94, information4
        from ben_copy_entity_results
        where copy_entity_txn_id = p_copy_entity_txn_id
        and table_alias = 'PLN';

Line: 264

    cursor c1 is select copy_entity_result_id
        from ben_copy_entity_results
        where gs_parent_entity_result_id = p_copy_entity_result_id_node
        and table_alias = 'RMV' and dml_operation <> 'DELETE'
        and copy_entity_result_id <> p_copy_entity_result_id_val;

Line: 302

    cursor c1 is select copy_entity_result_id,gs_parent_entity_result_id
        from ben_copy_entity_results
        where copy_entity_txn_id = p_copy_entity_txn_id
        and table_alias = 'RMV' and dml_operation <> 'DELETE';

Line: 308

    cursor c2(node_id number) is select gs_parent_entity_result_id
        from ben_copy_entity_results
        where copy_entity_result_id = node_id
        and table_alias = 'RMN' and dml_operation <> 'DELETE';

Line: 314

    cursor c3(parent_node_id number,exclude_node_id number) is select copy_entity_result_id
        from ben_copy_entity_results
        where gs_parent_entity_result_id = parent_node_id
        and table_alias = 'RMN' and dml_operation <> 'DELETE'
        and copy_entity_result_id <> exclude_node_id;

Line: 408

  cursor c1(p_copy_entity_result_id number) is select
    information13,information14,information15,information16,
    information169,information174,information221,information222,
    information166,information167,information306,information307,
    information223,information224,information225,information226
    from ben_copy_entity_results
    where copy_entity_result_id = p_copy_entity_result_id
    and table_alias = 'RMV' and dml_operation <> 'DELETE';

Line: 495

 cursor c1 is Select count(information1) from ben_copy_entity_results
            Where copy_entity_txn_id = p_copy_entity_txn_id and table_alias = 'RCR'
            group by information1;

Line: 686

cursor c1 is select Information1
        from ben_copy_entity_results
        where
        table_alias = 'RCR' and dml_operation <> 'DELETE'
        and copy_entity_txn_id = p_copy_entity_txn_id;

Line: 705

        select name into l_crit_rate_defn_name from pqh_criteria_rate_defn_vl where criteria_rate_defn_id = l_criteria_rate_defn;

Line: 707

        select count(*) into l_count from ben_copy_entity_results
            where
            table_alias = 'RMR' and dml_operation <> 'DELETE'
            and copy_entity_txn_id = p_copy_entity_txn_id
            and Information162 = l_criteria_rate_defn;