DBA Data[Home] [Help]

APPS.PAY_P45_PKG dependencies on HR_LOOKUPS

Line 534: FROM HR_LOOKUPS hr

530: close get_country;
531: begin
532: SELECT substr(hr.meaning,1,30)
533: INTO X_REGION_1
534: FROM HR_LOOKUPS hr
535: WHERE hr.LOOKUP_CODE = l_county
536: AND hr.LOOKUP_TYPE = 'GB_COUNTY';
537: EXCEPTION WHEN NO_DATA_FOUND THEN
538: null;