APPS.AHL_PRD_WORKORDER_PUB dependencies on FND_LOOKUPS

Line 443: FROM fnd_Lookups

439:
440: CURSOR get_status_csr(status VARCHAR)
441: IS
442: SELECT lookup_code
443: FROM fnd_Lookups
444: WHERE lookup_type = 'AHL_JOB_STATUS'
445: AND meaning = status;
446:
447: CURSOR validate_status_csr(c_status_new VARCHAR, c_status_old VARCHAR)

Line 2533: FROM fnd_Lookups

2529:
2530: CURSOR get_status_csr(status VARCHAR)
2531: IS
2532: SELECT lookup_code
2533: FROM fnd_Lookups
2534: WHERE lookup_type = 'AHL_JOB_STATUS'
2535: AND meaning = status;
2536:
2537: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;