DBA Data[Home] [Help]

APPS.AME_UTIL dependencies on HR_ORGANIZATION_UNITS

Line 725: tempName hr_organization_units.name%type;

721: raise;
722: return(null);
723: end getMonthString;
724: function getOrgName(orgIdIn in integer) return varchar2 as
725: tempName hr_organization_units.name%type;
726: begin
727: if(orgIdIn is null) then
728: return(null);
729: end if;

Line 732: from hr_organization_units

728: return(null);
729: end if;
730: select name
731: into tempName
732: from hr_organization_units
733: where
734: organization_id = orgIdIn and
735: trunc(sysdate) >= date_from and
736: (date_to is null or trunc(sysdate) < date_to);