DBA Data[Home] [Help]

APPS.AME_RULE_PKG dependencies on HR_ORGANIZATION_UNITS

Line 529: organizationName hr_organization_units.name%type;

525: raise;
526: return(null);
527: end getLMConditionId;
528: function getOrganizationName(organizationIdIn in integer) return varchar2 as
529: organizationName hr_organization_units.name%type;
530: begin
531: select name
532: into organizationName
533: from hr_organization_units

Line 533: from hr_organization_units

529: organizationName hr_organization_units.name%type;
530: begin
531: select name
532: into organizationName
533: from hr_organization_units
534: where
535: sysdate >= date_from and
536: organization_id = organizationIdIn and
537: (date_to is null or sysdate < date_to);