DBA Data[Home] [Help]

APPS.HR_CONTACT_API dependencies on PER_BUSINESS_GROUPS

Line 126: from per_business_groups

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';

Line 128: l_legislation_code per_business_groups.legislation_code%type;

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;

Line 804: from per_business_groups

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';

Line 806: l_legislation_code per_business_groups.legislation_code%type;

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;