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
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: