APPS.HZ_MATCH_RULE_COMPILE dependencies on FND_LOOKUP_VALUES

Line 7372: SELECT tag INTO l_cpt_type FROM fnd_lookup_values

7368: l(' l_contact_list(1).'||ATTRS.attribute_name||':= AttrVals('||ATTRS.attribute_id||');');
7369: d(fnd_log.level_statement,'l_contact_list(1).'||ATTRS.attribute_name,'AttrVals('||ATTRS.attribute_id||')');
7370: ELSIF ATTRS.entity_name='CONTACT_POINTS' THEN
7371: BEGIN
7372: SELECT tag INTO l_cpt_type FROM fnd_lookup_values
7373: WHERE lookup_type = 'HZ_DQM_CPT_ATTR_TYPE'
7374: AND lookup_code = ATTRS.attribute_name
7375: AND ROWNUM=1;
7376: EXCEPTION

Line 11778: SELECT tag INTO l_cpt_type FROM fnd_lookup_values

11774: l(' l_contact_list(1).'||ATTRS.attribute_name||':= AttrVals('||ATTRS.attribute_id||');');
11775: d(fnd_log.level_statement,'l_contact_list(1).'||ATTRS.attribute_name,'AttrVals('||ATTRS.attribute_id||')');
11776: ELSIF ATTRS.entity_name='CONTACT_POINTS' THEN
11777: BEGIN
11778: SELECT tag INTO l_cpt_type FROM fnd_lookup_values
11779: WHERE lookup_type = 'HZ_DQM_CPT_ATTR_TYPE'
11780: AND lookup_code = ATTRS.attribute_name
11781: AND ROWNUM=1;
11782: EXCEPTION