DBA Data[Home] [Help]

APPS.PAY_P45_PKG dependencies on HR_LOOKUPS

Line 591: FROM HR_LOOKUPS hr

587: close get_country;
588: begin
589: SELECT substr(hr.meaning,1,30)
590: INTO X_REGION_1
591: FROM HR_LOOKUPS hr
592: WHERE hr.LOOKUP_CODE = l_county
593: AND hr.LOOKUP_TYPE = 'GB_COUNTY';
594: EXCEPTION WHEN NO_DATA_FOUND THEN
595: null;