DBA Data[Home] [Help]

APPS.GHR_RIF_PKG dependencies on PER_ORGANIZATION_UNITS

Line 844: function get_org_name(p_organization_id IN per_organization_units.organization_id%TYPE)

840: --
841: END check_unique_name;
842:
843:
844: function get_org_name(p_organization_id IN per_organization_units.organization_id%TYPE)
845: return varchar2 is
846: cursor org_units is
847: select name
848: from per_organization_units porg

Line 848: from per_organization_units porg

844: function get_org_name(p_organization_id IN per_organization_units.organization_id%TYPE)
845: return varchar2 is
846: cursor org_units is
847: select name
848: from per_organization_units porg
849: where porg.organization_id = p_organization_id;
850:
851: l_name per_organization_units.name%TYPE;
852:

Line 851: l_name per_organization_units.name%TYPE;

847: select name
848: from per_organization_units porg
849: where porg.organization_id = p_organization_id;
850:
851: l_name per_organization_units.name%TYPE;
852:
853: begin
854: for org_units_rec in org_units
855: loop