APPS.HZ_PARTY_SEARCH SQL Statements

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

Line: 74

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 475

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 894

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 1290

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 1689

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 2083

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 2477

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 2911

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 3594

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 4230

        select attribute_id into l_id  
        from hz_trans_attributes_b  
        where entity_name = substrb(p_str, 0, l_pl - 1)  
        and ATTRIBUTE_NAME = substrb(p_str, l_pl + 1);  

Line: 4471

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 4890

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 5307

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 5727

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 6147

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 6539

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;