APPS.AHL_WF_MAPPING_PVT dependencies on FND_LOOKUPS

Line 273: FROM FND_LOOKUPS

269: */
270:
271: CURSOR c_appl_usg IS
272: SELECT LOOKUP_CODE
273: FROM FND_LOOKUPS
274: WHERE MEANING = l_Wf_Mapping_rec.APPLICATION_USG
275: AND LOOKUP_TYPE = 'AHL_APPLICATION_USAGE_CODE';
276:
277:

Line 519: FROM FND_LOOKUPS

515: where PROCESS_NAME = p_wf_mapping_rec.WF_PROCESS_NAME;
516:
517: CURSOR c_appl_usg IS
518: SELECT LOOKUP_CODE
519: FROM FND_LOOKUPS
520: WHERE MEANING = l_Wf_Mapping_rec.APPLICATION_USG
521: AND LOOKUP_TYPE = 'AHL_APPLICATION_USAGE_CODE';
522:
523:

Line 1122: SELECT 1 FROM FND_LOOKUPS

1118: )
1119: IS
1120: l_count NUMBER;
1121: CURSOR chk_appl_usg_code IS
1122: SELECT 1 FROM FND_LOOKUPS
1123: WHERE meaning = p_wf_mapping_rec.Application_Usg
1124: AND LOOKUP_TYPE = 'AHL_APPLICATION_USAGE_CODE';
1125: BEGIN
1126: OPEN chk_appl_usg_code ;

Line 1262: FROM FND_LOOKUPS

1258: l_valid_flag VARCHAR2(1);
1259: --l_application_usg_code VARCHAR2(30);
1260: /* CURSOR c_appl_usg IS
1261: SELECT LOOKUP_CODE
1262: FROM FND_LOOKUPS
1263: WHERE MEANING = p_Wf_Mapping_rec.application_usg
1264: AND LOOKUP_TYPE = 'AHL_APPLICATION_USAGE_CODE';*/
1265: BEGIN
1266: x_return_status := Fnd_Api.g_ret_sts_success;

Line 1289: -- from fnd_lookups

1285: END IF;
1286:
1287: -- Reema:
1288: -- Retrieve the application usage code
1289: -- from fnd_lookups
1290: /*OPEN c_appl_usg;
1291: FETCH c_appl_usg INTO l_application_usg_code;
1292: IF c_appl_usg%NOTFOUND THEN
1293: l_application_usg_code := NULL;