APPS.HZ_RELATIONSHIP_V2PUB dependencies on FND_LOOKUP_VALUES_VL

Line 573: -- Bug 3664939 : Use fnd_lookup_values_vl to get lookup meaning

569: -- there is already a parent, so raise error
570: --Bug 3306941.The meaning is to be displayed instead of the lookup_code.
571: SELECT MEANING
572: INTO l_meaning
573: -- Bug 3664939 : Use fnd_lookup_values_vl to get lookup meaning
574: FROM FND_LOOKUP_VALUES_VL
575: WHERE LOOKUP_TYPE = 'HZ_RELATIONSHIP_TYPE'
576: AND LOOKUP_CODE = p_relationship_rec.relationship_type
577: AND VIEW_APPLICATION_ID = 222

Line 574: FROM FND_LOOKUP_VALUES_VL

570: --Bug 3306941.The meaning is to be displayed instead of the lookup_code.
571: SELECT MEANING
572: INTO l_meaning
573: -- Bug 3664939 : Use fnd_lookup_values_vl to get lookup meaning
574: FROM FND_LOOKUP_VALUES_VL
575: WHERE LOOKUP_TYPE = 'HZ_RELATIONSHIP_TYPE'
576: AND LOOKUP_CODE = p_relationship_rec.relationship_type
577: AND VIEW_APPLICATION_ID = 222
578: AND ROWNUM =1;

Line 1565: -- Bug 3664939 : Use fnd_lookup_values_vl to get lookup meaning

1561: -- there is already a parent, so raise error
1562: --Bug 3306941.Display meaning instead of relationship_type.
1563: SELECT MEANING
1564: INTO l_meaning
1565: -- Bug 3664939 : Use fnd_lookup_values_vl to get lookup meaning
1566: FROM FND_LOOKUP_VALUES_VL
1567: WHERE LOOKUP_TYPE='HZ_RELATIONSHIP_TYPE'
1568: AND LOOKUP_CODE = l_relationship_type
1569: AND VIEW_APPLICATION_ID = 222

Line 1566: FROM FND_LOOKUP_VALUES_VL

1562: --Bug 3306941.Display meaning instead of relationship_type.
1563: SELECT MEANING
1564: INTO l_meaning
1565: -- Bug 3664939 : Use fnd_lookup_values_vl to get lookup meaning
1566: FROM FND_LOOKUP_VALUES_VL
1567: WHERE LOOKUP_TYPE='HZ_RELATIONSHIP_TYPE'
1568: AND LOOKUP_CODE = l_relationship_type
1569: AND VIEW_APPLICATION_ID = 222
1570: AND ROWNUM = 1;