DBA Data[Home] [Help]

APPS.IRC_PARTY_API dependencies on PER_BUSINESS_GROUPS_PERF

Line 119: l_legislation_code per_business_groups_perf.legislation_code%type;

115: l_comment_id per_all_people_f.comment_id%type;
116: l_name_combination_warning boolean;
117: l_orig_hire_warning boolean;
118: l_assign_payroll_warning boolean;
119: l_legislation_code per_business_groups_perf.legislation_code%type;
120: l_ptu_person_type_id number(15);
121: l_employee_number per_all_people_f.employee_number%type := hr_api.g_varchar2;
122: --
123: -- for disabling the descriptive flex field

Line 127: -- cursor to select the legislation from per_business_groups_perf

123: -- for disabling the descriptive flex field
124: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
125: hr_dflex_utility.l_ignore_dfcode_varray();
126: --
127: -- cursor to select the legislation from per_business_groups_perf
128: -- corresponding to the business group
129: --
130: cursor csr_legislation_code(p_business_group_id number) is
131: select legislation_code

Line 132: from per_business_groups_perf

128: -- corresponding to the business group
129: --
130: cursor csr_legislation_code(p_business_group_id number) is
131: select legislation_code
132: from per_business_groups_perf
133: where business_group_id = p_business_group_id;
134: --
135: -- cursor to select the person_type_id from hr_organization_inforamtion
136: -- corresponding to the recruiting flexfield on the business group

Line 873: l_legislation_code per_business_groups_perf.legislation_code%type;

869: l_full_name per_all_people_f.full_name%type;
870: l_comment_id per_all_people_f.comment_id%type;
871: l_name_combination_warning boolean;
872: l_orig_hire_warning boolean;
873: l_legislation_code per_business_groups_perf.legislation_code%type;
874: l_ptu_person_type_id number(15);
875: --
876: -- for disabling the descriptive flex field
877: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=

Line 880: -- cursor to select the legislation from per_business_groups_perf

876: -- for disabling the descriptive flex field
877: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
878: hr_dflex_utility.l_ignore_dfcode_varray();
879: --
880: -- cursor to select the legislation from per_business_groups_perf
881: -- corresponding to the business group
882: --
883: cursor csr_legislation_code(p_business_group_id number) is
884: select legislation_code

Line 885: from per_business_groups_perf

881: -- corresponding to the business group
882: --
883: cursor csr_legislation_code(p_business_group_id number) is
884: select legislation_code
885: from per_business_groups_perf
886: where business_group_id = p_business_group_id;
887: --
888: -- cursor to select the person_type_id from hr_organization_inforamtion
889: -- corresponding to the recruiting flexfield on the business group