553: WHERE Approval_object IS NULL
554: AND APPLICATION_USG_CODE = in_appl_usg_code;
555:
556: CURSOR chk_appl_usg_code IS 557: SELECT 1 FROM FND_LOOKUPS 558: WHERE lookup_code = p_application_usg_code
559: AND LOOKUP_TYPE = 'AHL_APPLICATION_USAGE_CODE';
560: BEGIN
561: OPEN chk_appl_usg_code;