DBA Data[Home] [Help]

APPS.PER_CN_ADD_LEG_HOOK dependencies on FND_TERRITORIES_VL

Line 78: l_territory_code fnd_territories_vl.territory_code%TYPE;

74: ,p_country IN VARCHAR2
75: ,p_postal_code IN VARCHAR2) AS
76:
77: l_proc VARCHAR2(72) := g_package||'check_address';
78: l_territory_code fnd_territories_vl.territory_code%TYPE;
79:
80: CURSOR csr_country (p_country VARCHAR2) IS
81: SELECT territory_code
82: FROM fnd_territories_vl

Line 82: FROM fnd_territories_vl

78: l_territory_code fnd_territories_vl.territory_code%TYPE;
79:
80: CURSOR csr_country (p_country VARCHAR2) IS
81: SELECT territory_code
82: FROM fnd_territories_vl
83: WHERE territory_code = p_country;
84:
85: BEGIN
86: