DBA Data[Home] [Help]

APPS.PAY_ADHOC_UTILS_PKG dependencies on FND_TERRITORIES_VL

Line 124: l_territory_short_name fnd_territories_vl.territory_short_name%type;

120: p_business_group_id number )
121: RETURN VARCHAR2
122: IS
123: --
124: l_territory_short_name fnd_territories_vl.territory_short_name%type;
125: l_proc constant varchar2(72) := g_package||'decode_OPM_territory';
126:
127: cursor csr_territory is
128: select territory_short_name

Line 129: from fnd_territories_vl

125: l_proc constant varchar2(72) := g_package||'decode_OPM_territory';
126:
127: cursor csr_territory is
128: select territory_short_name
129: from fnd_territories_vl
130: where territory_code = nvl(p_territory_code, hr_api.return_legislation_code(p_business_group_id));
131: --
132: BEGIN
133: --