APPS.AHL_PRD_NONROUTINE_PUB dependencies on FND_LOOKUP_VALUES

Line 620: FND_LOOKUP_VALUES FLVT,

616: x_create_nr_output_rec.problem_code_meaning,
617: x_create_nr_output_rec.resolution_code,
618: x_create_nr_output_rec.resolution_code_meaning
619: FROM cs_incidents_all_b CS,
620: FND_LOOKUP_VALUES FLVT,
621: FND_LOOKUP_VALUES FLVT1
622: WHERE FLVT.LOOKUP_TYPE(+) = 'REQUEST_PROBLEM_CODE'
623: AND FLVT.LOOKUP_CODE(+) = CS.PROBLEM_CODE
624: AND FLVT1.LOOKUP_TYPE(+) = 'REQUEST_RESOLUTION_CODE'

Line 621: FND_LOOKUP_VALUES FLVT1

617: x_create_nr_output_rec.resolution_code,
618: x_create_nr_output_rec.resolution_code_meaning
619: FROM cs_incidents_all_b CS,
620: FND_LOOKUP_VALUES FLVT,
621: FND_LOOKUP_VALUES FLVT1
622: WHERE FLVT.LOOKUP_TYPE(+) = 'REQUEST_PROBLEM_CODE'
623: AND FLVT.LOOKUP_CODE(+) = CS.PROBLEM_CODE
624: AND FLVT1.LOOKUP_TYPE(+) = 'REQUEST_RESOLUTION_CODE'
625: AND FLVT1.LOOKUP_CODE(+) = CS.RESOLUTION_CODE

Line 805: FND_LOOKUP_VALUES FLVT,

801: x_create_nr_output_rec.problem_code_meaning,
802: x_create_nr_output_rec.resolution_code,
803: x_create_nr_output_rec.resolution_code_meaning
804: FROM cs_incidents_all_b CS,
805: FND_LOOKUP_VALUES FLVT,
806: FND_LOOKUP_VALUES FLVT1
807: WHERE FLVT.LOOKUP_TYPE(+) = 'REQUEST_PROBLEM_CODE'
808: AND FLVT.LOOKUP_CODE(+) = CS.PROBLEM_CODE
809: AND FLVT1.LOOKUP_TYPE(+) = 'REQUEST_RESOLUTION_CODE'

Line 806: FND_LOOKUP_VALUES FLVT1

802: x_create_nr_output_rec.resolution_code,
803: x_create_nr_output_rec.resolution_code_meaning
804: FROM cs_incidents_all_b CS,
805: FND_LOOKUP_VALUES FLVT,
806: FND_LOOKUP_VALUES FLVT1
807: WHERE FLVT.LOOKUP_TYPE(+) = 'REQUEST_PROBLEM_CODE'
808: AND FLVT.LOOKUP_CODE(+) = CS.PROBLEM_CODE
809: AND FLVT1.LOOKUP_TYPE(+) = 'REQUEST_RESOLUTION_CODE'
810: AND FLVT1.LOOKUP_CODE(+) = CS.RESOLUTION_CODE