DBA Data[Home] [Help]

APPS.PER_APPLICANT_PKG dependencies on FND_TERRITORIES_VL

Line 2174: l_return_value fnd_territories_vl.territory_short_name%type := null ;

2170: end pre_update ;
2171:
2172: function get_territory_short_name ( p_territory_code in varchar2 )
2173: return varchar2 is
2174: l_return_value fnd_territories_vl.territory_short_name%type := null ;
2175: --
2176: cursor get_territory_short_name is
2177: select territory_short_name
2178: from fnd_territories_vl

Line 2178: from fnd_territories_vl

2174: l_return_value fnd_territories_vl.territory_short_name%type := null ;
2175: --
2176: cursor get_territory_short_name is
2177: select territory_short_name
2178: from fnd_territories_vl
2179: where territory_code = p_territory_code ;
2180: begin
2181:
2182: if ( p_territory_code is not null ) then