APPS.AHL_VWP_RULES_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 827: FROM FND_LOOKUP_VALUES_VL

823: END IF;
824: IF (p_lookup_code IS NOT NULL) THEN
825: IF (p_check_id_flag = 'Y') THEN
826: SELECT Lookup_Code INTO x_lookup_code
827: FROM FND_LOOKUP_VALUES_VL
828: WHERE Lookup_Type = p_lookup_type
829: AND Lookup_Code = p_lookup_code
830: AND enabled_flag = 'Y' --sowsubra FP:Bug#5758829
831: AND SYSDATE BETWEEN nvl(start_date_active,sysdate) --Sowmya Bug#5715342

Line 838: FROM FND_LOOKUP_VALUES_VL

834: x_lookup_code := p_lookup_code;
835: END IF;
836: ELSE
837: SELECT Lookup_Code INTO x_lookup_code
838: FROM FND_LOOKUP_VALUES_VL
839: WHERE Lookup_Type = p_lookup_type
840: AND Meaning = p_meaning
841: AND enabled_flag = 'Y' --sowsubra FP:Bug#5758829
842: AND SYSDATE BETWEEN nvl(start_date_active,sysdate) --sowsubra FP:Bug#5758829

Line 3015: FROM AHL_WORKORDERS AWO, FND_LOOKUP_VALUES_VL FLV

3011:
3012: -- To find if job exists for the visit at shop floor not in Cancelled-7 Or Deleted-22
3013: CURSOR c_job(x_id IN NUMBER) IS
3014: SELECT AWO.STATUS_CODE, FLV.MEANING
3015: FROM AHL_WORKORDERS AWO, FND_LOOKUP_VALUES_VL FLV
3016: WHERE AWO.VISIT_ID = x_id
3017: AND AWO.STATUS_CODE <> 7 AND AWO.STATUS_CODE <> 22
3018: AND FLV.LOOKUP_TYPE(+) = 'AHL_JOB_STATUS'
3019: AND AWO.STATUS_CODE = FLV.LOOKUP_CODE(+)

Line 3026: FROM AHL_WORKORDERS AWO, FND_LOOKUP_VALUES_VL FLV

3022:
3023: -- To find if job exists for the Task/MR at shop floor not in Cancelled-7 Or Deleted-22
3024: CURSOR c_job_tsk(x_id IN NUMBER)IS
3025: SELECT AWO.STATUS_CODE, FLV.MEANING
3026: FROM AHL_WORKORDERS AWO, FND_LOOKUP_VALUES_VL FLV
3027: WHERE AWO.VISIT_TASK_ID = x_id
3028: AND AWO.STATUS_CODE <> 7 AND AWO.STATUS_CODE <> 22
3029: AND FLV.LOOKUP_TYPE(+) = 'AHL_JOB_STATUS'
3030: AND AWO.STATUS_CODE = FLV.LOOKUP_CODE(+);