APPS.AHL_PRD_DF_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 939: FROM fnd_lookup_values_vl

935: -- R12: UMP Deferral.
936: -- Validate user deferral type.
937: CURSOR validate_user_defer_csr(p_user_defer_type IN VARCHAR2) IS
938: SELECT 'x'
939: FROM fnd_lookup_values_vl
940: WHERE lookup_type = 'AHL_PRD_DEFERRAL_TYPE'
941: AND lookup_code = p_user_defer_type
942: AND enabled_flag = 'Y'
943: AND trunc(sysdate) BETWEEN start_date_active AND nvl(end_date_active, sysdate+1);

Line 1350: SELECT 'x' FROM fnd_lookup_values_vl fnd

1346: exit_flag boolean := false;
1347: l_string VARCHAR2(30);
1348:
1349: CURSOR val_reason_code_csr(p_reason_code IN VARCHAR2) IS
1350: SELECT 'x' FROM fnd_lookup_values_vl fnd
1351: WHERE fnd.lookup_code = p_reason_code
1352: AND fnd.lookup_type = 'AHL_PRD_DF_REASON_TYPES';
1353:
1354: l_exists VARCHAR2(1);

Line 4000: FROM fnd_lookup_values_vl

3996: FETCH chk_inst_in_job INTO l_temp;
3997: IF (chk_inst_in_job%FOUND) THEN
3998: --Get status meaning
3999: SELECT meaning INTO l_status_meaning
4000: FROM fnd_lookup_values_vl
4001: WHERE lookup_type = 'AHL_JOB_STATUS'
4002: AND LOOKUP_CODE = l_prd_workorder_rec.status_code;
4003: FND_MESSAGE.set_name('AHL','AHL_PRD_MAT_NOT_RETURN');
4004: FND_MESSAGE.set_token('WO_STATUS', l_status_meaning);

Line 5013: SELECT meaning FROM FND_LOOKUP_VALUES_VL

5009: AND APPLICATION_USG_CODE = RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))) ;--this takes care of app_usage changes
5010:
5011: -- mr status meaning has to be fecthed seperately because function returns only code
5012: CURSOR mr_status_meaning_csr(p_status_code IN VARCHAR2)IS
5013: SELECT meaning FROM FND_LOOKUP_VALUES_VL
5014: WHERE lookup_code = p_status_code
5015: AND lookup_type = 'AHL_PRD_MR_STATUS';
5016:
5017: -- to fetch visit info

Line 5089: FROM ahl_unit_deferrals_vl,fnd_lookup_values_vl FLV, fnd_lookup_values_vl DTYP

5085: -- to fetch df_header_rec
5086: CURSOR df_header_info_csr(p_unit_effectivity_id IN NUMBER) IS
5087: SELECT unit_deferral_id, object_version_number, approval_status_code,FLV.meaning approval_status_meaning,defer_reason_code,skip_mr_flag,
5088: affect_due_calc_flag, set_due_date, deferral_effective_on,remarks,approver_notes, user_deferral_type, DTYP.meaning user_deferral_mean
5089: FROM ahl_unit_deferrals_vl,fnd_lookup_values_vl FLV, fnd_lookup_values_vl DTYP
5090: WHERE unit_deferral_type = 'DEFERRAL'
5091: AND unit_effectivity_id = p_unit_effectivity_id
5092: AND FLV.lookup_code = approval_status_code
5093: AND FLV.lookup_type = 'AHL_PRD_DF_APPR_STATUS_TYPES'