APPS.PER_FR_D2_PKG dependencies on FND_COMMON_LOOKUPS

Line 476: from fnd_common_lookups

472: l_unused_number := 0;
473: --Then check whether there is mapping or not
474: select count(lookup_code)
475: into l_unused_number
476: from fnd_common_lookups
477: where lookup_type = 'FR_PCS_CODE'
478: and description = p_pcs_code;
479: IF l_unused_number = 1 THEN
480: -- If there is more than one or zero old pcs code for the given new code, then the new code is printed

Line 484: from fnd_common_lookups

480: -- If there is more than one or zero old pcs code for the given new code, then the new code is printed
481: -- No error message is given for this
482: select lookup_code
483: into p_pcs_code
484: from fnd_common_lookups
485: where lookup_type = 'FR_PCS_CODE'
486: and description = p_pcs_code;
487: END IF;
488: END IF; --Ignore when it is a old code

Line 497: from fnd_common_lookups

493: IF ascii(substr(p_pcs_code, -1 )) >= ascii(0) AND ascii(substr(p_pcs_code, -1)) <= ascii(9) THEN
494: --Then check whether there is mapping or not
495: select description
496: into l_unused_char
497: from fnd_common_lookups
498: where lookup_type = 'FR_PCS_CODE'
499: and lookup_code = p_pcs_code;
500: IF l_unused_char IS NULL THEN
501: --Get the job name