122:
123: -- Bug 3406332 starts here.
124: cursor csr_get_legislation_code is
125: select legislation_code
126: from per_business_groups
127: where business_group_id = p_business_group_id;
128: l_legislation_code per_business_groups.legislation_code%type;
129: -- 3406332 ends here.
130: l_proc varchar2(72) := g_package||'create_person';
124: cursor csr_get_legislation_code is
125: select legislation_code
126: from per_business_groups
127: where business_group_id = p_business_group_id;
128: l_legislation_code per_business_groups.legislation_code%type;
129: -- 3406332 ends here.
130: l_proc varchar2(72) := g_package||'create_person';
131: l_person_type_id per_person_types.person_type_id%type:=
132: p_person_type_id;
800:
801: -- Bug 3406332 starts here.
802: cursor csr_get_legislation_code is
803: select legislation_code
804: from per_business_groups
805: where business_group_id = p_business_group_id;
806: l_legislation_code per_business_groups.legislation_code%type;
807: -- 3406332 ends here.
808: l_proc varchar2(72) := g_package||'create_person';
802: cursor csr_get_legislation_code is
803: select legislation_code
804: from per_business_groups
805: where business_group_id = p_business_group_id;
806: l_legislation_code per_business_groups.legislation_code%type;
807: -- 3406332 ends here.
808: l_proc varchar2(72) := g_package||'create_person';
809: l_person_type_id per_person_types.person_type_id%type:=
810: p_person_type_id;