DBA Data[Home] [Help]

APPS.IRC_PARTY_API dependencies on PER_BUSINESS_GROUPS_PERF

Line 114: l_legislation_code per_business_groups_perf.legislation_code%type;

110: l_comment_id per_all_people_f.comment_id%type;
111: l_name_combination_warning boolean;
112: l_orig_hire_warning boolean;
113: l_assign_payroll_warning boolean;
114: l_legislation_code per_business_groups_perf.legislation_code%type;
115: l_ptu_person_type_id number(15);
116: l_employee_number per_all_people_f.employee_number%type := hr_api.g_varchar2;
117: --
118: -- for disabling the descriptive flex field

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

118: -- for disabling the descriptive flex field
119: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
120: hr_dflex_utility.l_ignore_dfcode_varray();
121: --
122: -- cursor to select the legislation from per_business_groups_perf
123: -- corresponding to the business group
124: --
125: cursor csr_legislation_code(p_business_group_id number) is
126: select legislation_code

Line 127: from per_business_groups_perf

123: -- corresponding to the business group
124: --
125: cursor csr_legislation_code(p_business_group_id number) is
126: select legislation_code
127: from per_business_groups_perf
128: where business_group_id = p_business_group_id;
129: --
130: -- cursor to select the person_type_id from hr_organization_inforamtion
131: -- corresponding to the recruiting flexfield on the business group

Line 846: l_legislation_code per_business_groups_perf.legislation_code%type;

842: l_full_name per_all_people_f.full_name%type;
843: l_comment_id per_all_people_f.comment_id%type;
844: l_name_combination_warning boolean;
845: l_orig_hire_warning boolean;
846: l_legislation_code per_business_groups_perf.legislation_code%type;
847: l_ptu_person_type_id number(15);
848: --
849: -- for disabling the descriptive flex field
850: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=

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

849: -- for disabling the descriptive flex field
850: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
851: hr_dflex_utility.l_ignore_dfcode_varray();
852: --
853: -- cursor to select the legislation from per_business_groups_perf
854: -- corresponding to the business group
855: --
856: cursor csr_legislation_code(p_business_group_id number) is
857: select legislation_code

Line 858: from per_business_groups_perf

854: -- corresponding to the business group
855: --
856: cursor csr_legislation_code(p_business_group_id number) is
857: select legislation_code
858: from per_business_groups_perf
859: where business_group_id = p_business_group_id;
860: --
861: -- cursor to select the person_type_id from hr_organization_inforamtion
862: -- corresponding to the recruiting flexfield on the business group