DBA Data[Home] [Help]

APPS.AHL_PRD_PRINT_PVT dependencies on AHL_MC_RELATIONSHIPS

Line 8555: FROM ahl_mc_relationships MC,

8551: IF (l_relationship_id IS NOT NULL) THEN
8552: BEGIN
8553: SELECT FLV.meaning
8554: INTO l_position_meaning
8555: FROM ahl_mc_relationships MC,
8556: FND_LOOKUP_VALUES_VL FLV
8557: WHERE FLV.LOOKUP_CODE = MC.POSITION_REF_CODE
8558: AND FLV.LOOKUP_TYPE = 'AHL_POSITION_REFERENCE'
8559: AND FLV.ENABLED_FLAG = 'Y'