APPS.HZ_RELATIONSHIP_V2PUB dependencies on FND_LOOKUP_VALUES_VL

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

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

Line 572: FROM FND_LOOKUP_VALUES_VL

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

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

1553: -- there is already a parent, so raise error
1554: --Bug 3306941.Display meaning instead of relationship_type.
1555: SELECT MEANING
1556: INTO l_meaning
1557: -- Bug 3664939 : Use fnd_lookup_values_vl to get lookup meaning
1558: FROM FND_LOOKUP_VALUES_VL
1559: WHERE LOOKUP_TYPE='HZ_RELATIONSHIP_TYPE'
1560: AND LOOKUP_CODE = l_relationship_type
1561: AND VIEW_APPLICATION_ID = 222

Line 1558: FROM FND_LOOKUP_VALUES_VL

1554: --Bug 3306941.Display meaning instead of relationship_type.
1555: SELECT MEANING
1556: INTO l_meaning
1557: -- Bug 3664939 : Use fnd_lookup_values_vl to get lookup meaning
1558: FROM FND_LOOKUP_VALUES_VL
1559: WHERE LOOKUP_TYPE='HZ_RELATIONSHIP_TYPE'
1560: AND LOOKUP_CODE = l_relationship_type
1561: AND VIEW_APPLICATION_ID = 222
1562: AND ROWNUM = 1;