APPS.AHL_VWP_RULES_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 833: FROM FND_LOOKUP_VALUES_VL

829: END IF;
830: IF (p_lookup_code IS NOT NULL) THEN
831: IF (p_check_id_flag = 'Y') THEN
832: SELECT Lookup_Code INTO x_lookup_code
833: FROM FND_LOOKUP_VALUES_VL
834: WHERE Lookup_Type = p_lookup_type
835: AND Lookup_Code = p_lookup_code
836: AND enabled_flag = 'Y' --sowsubra FP:Bug#5758829
837: AND SYSDATE BETWEEN nvl(start_date_active,sysdate) --Sowmya Bug#5715342

Line 844: FROM FND_LOOKUP_VALUES_VL

840: x_lookup_code := p_lookup_code;
841: END IF;
842: ELSE
843: SELECT Lookup_Code INTO x_lookup_code
844: FROM FND_LOOKUP_VALUES_VL
845: WHERE Lookup_Type = p_lookup_type
846: AND Meaning = p_meaning
847: AND enabled_flag = 'Y' --sowsubra FP:Bug#5758829
848: AND SYSDATE BETWEEN nvl(start_date_active,sysdate) --sowsubra FP:Bug#5758829

Line 3334: FROM AHL_WORKORDERS AWO, FND_LOOKUP_VALUES_VL FLV

3330:
3331: -- To find if job exists for the visit at shop floor not in Cancelled-7 Or Deleted-22
3332: CURSOR c_job(x_id IN NUMBER) IS
3333: SELECT AWO.STATUS_CODE, FLV.MEANING
3334: FROM AHL_WORKORDERS AWO, FND_LOOKUP_VALUES_VL FLV
3335: WHERE AWO.VISIT_ID = x_id
3336: AND AWO.STATUS_CODE <> 7 AND AWO.STATUS_CODE <> 22
3337: AND FLV.LOOKUP_TYPE(+) = 'AHL_JOB_STATUS'
3338: AND AWO.STATUS_CODE = FLV.LOOKUP_CODE(+)

Line 3345: FROM AHL_WORKORDERS AWO, FND_LOOKUP_VALUES_VL FLV

3341:
3342: -- To find if job exists for the Task/MR at shop floor not in Cancelled-7 Or Deleted-22
3343: CURSOR c_job_tsk(x_id IN NUMBER)IS
3344: SELECT AWO.STATUS_CODE, FLV.MEANING
3345: FROM AHL_WORKORDERS AWO, FND_LOOKUP_VALUES_VL FLV
3346: WHERE AWO.VISIT_TASK_ID = x_id
3347: AND AWO.STATUS_CODE <> 7 AND AWO.STATUS_CODE <> 22
3348: AND FLV.LOOKUP_TYPE(+) = 'AHL_JOB_STATUS'
3349: AND AWO.STATUS_CODE = FLV.LOOKUP_CODE(+);

Line 4609: FND_LOOKUP_VALUES_VL LKUP1,

4605: FROM AHL_VISIT_TASKS_B ATSK,
4606: AHL_WARRANTY_ENTITLEMENTS ASWE,
4607: AHL_WARRANTY_CLAIMS_B AWCL,
4608: AHL_WARRANTY_CONTRACTS_B AWCB,
4609: FND_LOOKUP_VALUES_VL LKUP1,
4610: FND_LOOKUP_VALUES_VL LKUP2
4611: WHERE ATSK.VISIT_TASK_ID = ASWE.VISIT_TASK_ID(+)
4612: AND ASWE.WARRANTY_CONTRACT_ID = AWCB.WARRANTY_CONTRACT_ID(+)
4613: AND ASWE.WARRANTY_CLAIM_ID = AWCL.WARRANTY_CLAIM_ID(+)

Line 4610: FND_LOOKUP_VALUES_VL LKUP2

4606: AHL_WARRANTY_ENTITLEMENTS ASWE,
4607: AHL_WARRANTY_CLAIMS_B AWCL,
4608: AHL_WARRANTY_CONTRACTS_B AWCB,
4609: FND_LOOKUP_VALUES_VL LKUP1,
4610: FND_LOOKUP_VALUES_VL LKUP2
4611: WHERE ATSK.VISIT_TASK_ID = ASWE.VISIT_TASK_ID(+)
4612: AND ASWE.WARRANTY_CONTRACT_ID = AWCB.WARRANTY_CONTRACT_ID(+)
4613: AND ASWE.WARRANTY_CLAIM_ID = AWCL.WARRANTY_CLAIM_ID(+)
4614: AND LKUP1.LOOKUP_TYPE(+) = 'AHL_WARRANTY_ENTLMNT_STATUS'