DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_COMPILE dependencies on FND_LOOKUP_VALUES

Line 7333: SELECT tag INTO l_cpt_type FROM fnd_lookup_values

7329: l(' l_contact_list(1).'||ATTRS.attribute_name||':= AttrVals('||ATTRS.attribute_id||');');
7330: d(fnd_log.level_statement,'l_contact_list(1).'||ATTRS.attribute_name,'AttrVals('||ATTRS.attribute_id||')');
7331: ELSIF ATTRS.entity_name='CONTACT_POINTS' THEN
7332: BEGIN
7333: SELECT tag INTO l_cpt_type FROM fnd_lookup_values
7334: WHERE lookup_type = 'HZ_DQM_CPT_ATTR_TYPE'
7335: AND lookup_code = ATTRS.attribute_name
7336: AND ROWNUM=1;
7337: EXCEPTION

Line 11722: SELECT tag INTO l_cpt_type FROM fnd_lookup_values

11718: l(' l_contact_list(1).'||ATTRS.attribute_name||':= AttrVals('||ATTRS.attribute_id||');');
11719: d(fnd_log.level_statement,'l_contact_list(1).'||ATTRS.attribute_name,'AttrVals('||ATTRS.attribute_id||')');
11720: ELSIF ATTRS.entity_name='CONTACT_POINTS' THEN
11721: BEGIN
11722: SELECT tag INTO l_cpt_type FROM fnd_lookup_values
11723: WHERE lookup_type = 'HZ_DQM_CPT_ATTR_TYPE'
11724: AND lookup_code = ATTRS.attribute_name
11725: AND ROWNUM=1;
11726: EXCEPTION