20: p_session_date DATE)
21: return VARCHAR2 IS
22: --
23: l_return_value varchar2(240);
24: l_person_id per_people_f.person_id%TYPE;
25: l_legislation_code per_business_groups.legislation_code%TYPE;
26: l_proc varchar2(72) := g_package||'validate_national_identifier';
27: l_warning varchar2(1) :='N';
28: l_person_type_id per_people_f.person_type_id%TYPE;
24: l_person_id per_people_f.person_id%TYPE;
25: l_legislation_code per_business_groups.legislation_code%TYPE;
26: l_proc varchar2(72) := g_package||'validate_national_identifier';
27: l_warning varchar2(1) :='N';
28: l_person_type_id per_people_f.person_type_id%TYPE;
29: l_region_of_birth per_people_f.region_of_birth%TYPE;
30: l_country_of_birth per_people_f.country_of_birth%TYPE;
31: --
32: cursor csr_bg is
25: l_legislation_code per_business_groups.legislation_code%TYPE;
26: l_proc varchar2(72) := g_package||'validate_national_identifier';
27: l_warning varchar2(1) :='N';
28: l_person_type_id per_people_f.person_type_id%TYPE;
29: l_region_of_birth per_people_f.region_of_birth%TYPE;
30: l_country_of_birth per_people_f.country_of_birth%TYPE;
31: --
32: cursor csr_bg is
33: select legislation_code
26: l_proc varchar2(72) := g_package||'validate_national_identifier';
27: l_warning varchar2(1) :='N';
28: l_person_type_id per_people_f.person_type_id%TYPE;
29: l_region_of_birth per_people_f.region_of_birth%TYPE;
30: l_country_of_birth per_people_f.country_of_birth%TYPE;
31: --
32: cursor csr_bg is
33: select legislation_code
34: from per_business_groups pbg