APPS.PER_ANC_SHD dependencies on PER_SPECIAL_INFO_TYPES

Line 51: -- the id_flex_code 'PEA' and must exist within PER_SPECIAL_INFO_TYPES

47: l_proc varchar2(72) := g_package||'segment_combination_check';
48: l_discard number;
49: --
50: -- the cursor ancsel ensures the id_flex_num must be valid, enabled for
51: -- the id_flex_code 'PEA' and must exist within PER_SPECIAL_INFO_TYPES
52: -- for the business group.
53: --
54: cursor ancsel is
55: select 1

Line 56: from per_special_info_types pc,

52: -- for the business group.
53: --
54: cursor ancsel is
55: select 1
56: from per_special_info_types pc,
57: fnd_id_flex_structures fs
58: where fs.id_flex_num = pc.id_flex_num
59: and fs.id_flex_code = 'PEA'
60: and pc.enabled_flag = 'Y'

Line 74: -- per_special_info_types

70: where fs.id_flex_num = p_id_flex_num
71: and fs.id_flex_code = 'PEA';
72: --
73: -- the cursor ancerrsel2 determines if the id_flex_num is valid for
74: -- per_special_info_types
75: -- note: only called when cursor ancsel fails
76: --
77: cursor ancerrsel2 is
78: select 1

Line 79: from per_special_info_types pc

75: -- note: only called when cursor ancsel fails
76: --
77: cursor ancerrsel2 is
78: select 1
79: from per_special_info_types pc
80: where pc.business_group_id + 0 = p_business_group_id
81: and pc.id_flex_num = p_id_flex_num;
82:
83: --

Line 265: -- the row does not exist in PER_SPECIAL_INFO_TYPES

261: fetch ancerrsel2 into l_discard;
262: if ancerrsel2%notfound then
263: close ancerrsel2;
264: --
265: -- the row does not exist in PER_SPECIAL_INFO_TYPES
266: --
267: hr_utility.set_message(801, 'HR_51114_JBR_SPCIAL_NOT_EXIST');
268: hr_utility.raise_error;
269: end if;

Line 272: -- the row is not enabled in PER_SPECIAL_INFO_TYPES

268: hr_utility.raise_error;
269: end if;
270: close ancerrsel2;
271: --
272: -- the row is not enabled in PER_SPECIAL_INFO_TYPES
273: --
274: hr_utility.set_message(801, 'HR_51115_JBR_SPCIAL_NOT_ENABLE');
275: hr_utility.raise_error;
276: end if;