APPS.AHL_PRD_DF_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 966: FROM fnd_lookup_values_vl

962: -- R12: UMP Deferral.
963: -- Validate user deferral type.
964: CURSOR validate_user_defer_csr(p_user_defer_type IN VARCHAR2) IS
965: SELECT 'x'
966: FROM fnd_lookup_values_vl
967: WHERE lookup_type = 'AHL_PRD_DEFERRAL_TYPE'
968: AND lookup_code = p_user_defer_type
969: AND enabled_flag = 'Y'
970: AND trunc(sysdate) BETWEEN start_date_active AND nvl(end_date_active, sysdate+1);

Line 1402: SELECT 'x' FROM fnd_lookup_values_vl fnd

1398: exit_flag boolean := false;
1399: l_string VARCHAR2(30);
1400:
1401: CURSOR val_reason_code_csr(p_reason_code IN VARCHAR2) IS
1402: SELECT 'x' FROM fnd_lookup_values_vl fnd
1403: WHERE fnd.lookup_code = p_reason_code
1404: AND fnd.lookup_type = 'AHL_PRD_DF_REASON_TYPES';
1405:
1406: l_exists VARCHAR2(1);

Line 4156: FROM fnd_lookup_values_vl

4152: FETCH chk_inst_in_job INTO l_temp;
4153: IF (chk_inst_in_job%FOUND) THEN
4154: --Get status meaning
4155: SELECT meaning INTO l_status_meaning
4156: FROM fnd_lookup_values_vl
4157: WHERE lookup_type = 'AHL_JOB_STATUS'
4158: AND LOOKUP_CODE = l_prd_workorder_rec.status_code;
4159: FND_MESSAGE.set_name('AHL','AHL_PRD_MAT_NOT_RETURN');
4160: FND_MESSAGE.set_token('WO_STATUS', l_status_meaning);

Line 5391: SELECT meaning FROM FND_LOOKUP_VALUES_VL

5387: AND APPLICATION_USG_CODE = RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))) ;--this takes care of app_usage changes
5388:
5389: -- mr status meaning has to be fecthed seperately because function returns only code
5390: CURSOR mr_status_meaning_csr(p_status_code IN VARCHAR2)IS
5391: SELECT meaning FROM FND_LOOKUP_VALUES_VL
5392: WHERE lookup_code = p_status_code
5393: AND lookup_type = 'AHL_PRD_MR_STATUS';
5394:
5395: CURSOR ue_status_meaning_csr(p_status_code IN VARCHAR2)IS

Line 5396: SELECT meaning FROM FND_LOOKUP_VALUES_VL

5392: WHERE lookup_code = p_status_code
5393: AND lookup_type = 'AHL_PRD_MR_STATUS';
5394:
5395: CURSOR ue_status_meaning_csr(p_status_code IN VARCHAR2)IS
5396: SELECT meaning FROM FND_LOOKUP_VALUES_VL
5397: WHERE lookup_code = p_status_code
5398: AND lookup_type = 'AHL_UNIT_EFFECTIVITY_STATUS';
5399:
5400: -- to fetch visit info

Line 5479: FROM ahl_unit_deferrals_vl,fnd_lookup_values_vl FLV, fnd_lookup_values_vl DTYP

5475: ahl_unit_deferrals_vl.attribute8,ahl_unit_deferrals_vl.attribute9,ahl_unit_deferrals_vl.attribute10,ahl_unit_deferrals_vl.attribute11,
5476: ahl_unit_deferrals_vl.attribute12,ahl_unit_deferrals_vl.attribute13,ahl_unit_deferrals_vl.attribute14,ahl_unit_deferrals_vl.attribute15
5477: /*manisaga: added attributes for DFF Enablement on 22-Jan-2010--end */
5478:
5479: FROM ahl_unit_deferrals_vl,fnd_lookup_values_vl FLV, fnd_lookup_values_vl DTYP
5480: WHERE unit_deferral_type = 'DEFERRAL'
5481: AND unit_effectivity_id = p_unit_effectivity_id
5482: AND FLV.lookup_code = approval_status_code
5483: AND FLV.lookup_type = 'AHL_PRD_DF_APPR_STATUS_TYPES'