APPS.PE_AEI_BUS dependencies on PER_ASSIGNMENT_INFO_TYPES

Line 155: -- per_assignment_info_types where active_inactive_flag is 'Y'.

151: -- {Start Of Comments}
152: --
153: -- Description:
154: -- Validates that the assignment information type exists in table
155: -- per_assignment_info_types where active_inactive_flag is 'Y'.
156: --
157: -- Pre Conditions:
158: -- Data must be existed in table per_assignment_info_types.
159: --

Line 158: -- Data must be existed in table per_assignment_info_types.

154: -- Validates that the assignment information type exists in table
155: -- per_assignment_info_types where active_inactive_flag is 'Y'.
156: --
157: -- Pre Conditions:
158: -- Data must be existed in table per_assignment_info_types.
159: --
160: -- In Parameters:
161: -- p_information_type
162: --

Line 185: l_flag per_assignment_info_types.active_inactive_flag%type;

181: p_information_type in per_assignment_extra_info.information_type%type
182: ) is
183: --
184: l_proc varchar2(72) := g_package||'chk_assignment_info_type';
185: l_flag per_assignment_info_types.active_inactive_flag%type;
186: --
187: cursor c_asg_info_type (code varchar2) is
188: select aeit.active_inactive_flag
189: from per_assignment_info_types aeit

Line 189: from per_assignment_info_types aeit

185: l_flag per_assignment_info_types.active_inactive_flag%type;
186: --
187: cursor c_asg_info_type (code varchar2) is
188: select aeit.active_inactive_flag
189: from per_assignment_info_types aeit
190: where aeit.information_type = code;
191: --
192: Begin
193: hr_utility.set_location('Entering:'||l_proc, 1);

Line 340: l_multi_occur_flag per_assignment_info_types.multiple_occurences_flag%type;

336: ,p_assignment_id in per_assignment_extra_info.assignment_id%type
337: ) is
338: --
339: l_proc varchar2(72) := g_package||'chk_multiple_occurences_flag';
340: l_multi_occur_flag per_assignment_info_types.multiple_occurences_flag%type;
341: l_dummy varchar2(1);
342: l_found_poi boolean;
343: --
344: cursor c_multi_occur_flag (code varchar2) is

Line 346: from per_assignment_info_types

342: l_found_poi boolean;
343: --
344: cursor c_multi_occur_flag (code varchar2) is
345: select multiple_occurences_flag
346: from per_assignment_info_types
347: where information_type = code;
348: --
349: cursor c_get_row (code varchar2, id number) is
350: select 'x'