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: 455

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 854

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 1230

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 1609

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 1983

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 2357

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 2771

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 3418

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 4018

        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: 4259

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 4658

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 5055

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 5455

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 5853

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;

Line: 6225

    SELECT COMPILATION_FLAG 
    FROM HZ_MATCH_RULES_VL 
    WHERE MATCH_RULE_ID = p_rule_id;