APPS.IEU_UWQ_GET_NEXT_WORK_PVT dependencies on IEU_UWQ_SEL_ENUMERATORS

Line 758: IEU_UWQ_SEL_ENUMERATORS ENUM,

754: LKUPS.MEANING WORK_TYPE,
755: DECODE(STATUS_ID, 0, '', 1, LKUPS1.MEANING, 2, LKUPS1.MEANING) STATUS_CODE
756: INTO X_UWQM_WORKITEM_DATA(i)
757: FROM IEU_UWQM_ITEMS UWQM,
758: IEU_UWQ_SEL_ENUMERATORS ENUM,
759: IEU_UWQM_PRIORITIES_TL PR,
760: FND_LOOKUP_VALUES_VL LKUPS,
761: FND_LOOKUP_VALUES_VL LKUPS1
762: WHERE UWQM.WORK_ITEM_ID = l_nw_item_list(i).work_item_id

Line 4031: FROM FND_LOOKUP_VALUES_VL LKUPS, IEU_UWQ_SEL_ENUMERATORS ENUM

4027: BEGIN
4028:
4029: SELECT LKUPS.MEANING
4030: INTO L_WORK_TYPE
4031: FROM FND_LOOKUP_VALUES_VL LKUPS, IEU_UWQ_SEL_ENUMERATORS ENUM
4032: WHERE ENUM.ENUM_TYPE_UUID = p_dist_workitem_data(n).IEU_ENUM_TYPE_UUID
4033: AND LKUPS.LOOKUP_TYPE(+) = ENUM.WORK_Q_LABEL_LU_TYPE
4034: AND LKUPS.VIEW_APPLICATION_ID(+) = ENUM.APPLICATION_ID
4035: AND LKUPS.LOOKUP_CODE(+) = WORK_Q_LABEL_LU_CODE;

Line 4249: FROM FND_LOOKUP_VALUES_VL LKUPS, IEU_UWQ_SEL_ENUMERATORS ENUM

4245: BEGIN
4246:
4247: SELECT LKUPS.MEANING
4248: INTO L_WORK_TYPE
4249: FROM FND_LOOKUP_VALUES_VL LKUPS, IEU_UWQ_SEL_ENUMERATORS ENUM
4250: WHERE ENUM.ENUM_TYPE_UUID = p_dist_del_workitem_data.IEU_ENUM_TYPE_UUID
4251: AND LKUPS.LOOKUP_TYPE(+) = ENUM.WORK_Q_LABEL_LU_TYPE
4252: AND LKUPS.VIEW_APPLICATION_ID(+) = ENUM.APPLICATION_ID
4253: AND LKUPS.LOOKUP_CODE(+) = WORK_Q_LABEL_LU_CODE;