APPS.AHL_PRD_MTLTXN_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 169: FROM FND_LOOKUP_VALUES_VL

165:
166: -- Query for Selcting Problem_Code
167: CURSOR Fnd_Lookups_Cur(p_Lookup_Meaning varchar2) IS
168: SELECT LOOKUP_CODE
169: FROM FND_LOOKUP_VALUES_VL
170: WHERE MEANING = p_Lookup_Meaning
171: AND LOOKUP_TYPE = C_REQUEST_PROBLEM_CODE
172: AND ENABLED_FLAG = 'Y'
173: AND ((START_DATE_ACTIVE IS NULL) OR (START_DATE_ACTIVE <= SYSDATE))

Line 1898: FROM FND_LOOKUP_VALUES_VL

1894: -- Added for FP bug# 5903318.
1895: -- validate create_wo_option.
1896: CURSOR create_wo_cur(p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1897: SELECT meaning
1898: FROM FND_LOOKUP_VALUES_VL
1899: WHERE lookup_type = p_lookup_type
1900: AND lookup_code = p_lookup_code
1901: AND ENABLED_FLAG = 'Y'
1902: AND ((START_DATE_ACTIVE IS NULL) OR (START_DATE_ACTIVE <= SYSDATE))

Line 1922: l_fnd_meaning fnd_lookup_values_vl.meaning%TYPE;

1918: l_junk VARCHAR2(1);
1919: l_disposition_id NUMBER;
1920:
1921: -- Added for FP bug# 5903318.
1922: l_fnd_meaning fnd_lookup_values_vl.meaning%TYPE;
1923:
1924: -- Added for ER# 5854712.
1925: l_inv_locator_id NUMBER;
1926: l_project_id NUMBER;