DBA Data[Home] [Help]

APPS.HR_NI_CHK_PKG dependencies on PER_BUSINESS_GROUPS

Line 25: l_legislation_code per_business_groups.legislation_code%TYPE;

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;
29: l_region_of_birth per_people_f.region_of_birth%TYPE;

Line 34: from per_business_groups pbg

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
35: where pbg.business_group_id = p_business_group_id;
36: --
37: Begin
38: --