APPS.AML_LEAD_DEDUPE_PVT SQL Statements

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

Line: 94

         SELECT ruleattr.attribute_id, attr.NAME
           FROM pv_enty_select_criteria ruleattr, pv_attributes_vl attr
          WHERE ruleattr.process_rule_id = 60
            AND ruleattr.attribute_id = attr.attribute_id
            AND ruleattr.selection_type_code = 'CRITERION';

Line: 205

                SELECT   hzpc.party_id
                    FROM hz_parties hzpc,
                         hz_parties hzpr,
                         hz_relationships hzr
                   WHERE hzpc.party_id = p_dup_rec.contact_id
                     AND hzpc.party_id = hzr.subject_id
                     AND hzr.party_id = hzpr.party_id
                     AND hzr.relationship_code IN ('CONTACT_OF', 'EMPLOYEE_OF')
                ORDER BY hzpc.party_id DESC;

Line: 237

         SELECT   party_site_id, hzp.party_id
             FROM hz_locations hzl, hz_party_sites hzs, hz_parties hzp
            WHERE hzp.party_id = p_dup_rec.party_id
              AND hzp.party_id = hzs.party_id
              AND hzs.location_id = hzl.location_id
              AND hzs.party_site_id = p_dup_rec.party_site_id
         ORDER BY hzp.party_id DESC;

Line: 269

         SELECT attrvals.attribute_value
           FROM pv_enty_select_criteria ruleattr,
                pv_selected_attr_values attrvals
          WHERE ruleattr.process_rule_id = 60
            AND ruleattr.selection_type_code = 'INPUT_FILTER'
            AND ruleattr.selection_criteria_id = attrvals.selection_criteria_id;

Line: 314

      l_sql_string := 'SELECT sales_lead_id ';

Line: 400

insert into  aaa_log
values(sysdate, l_sql_string);

Line: 477

                l_sql_string   := 'SELECT count(distinct category_id) l_count ';