APPS.HR_SIT_API dependencies on PER_SPECIAL_INFO_TYPES

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

129: from per_business_groups pbg
130: where pbg.business_group_id = p_business_group_id;
131: --
132: -- the cursor ancsel ensures the id_flex_num must be valid, enabled for
133: -- the id_flex_code 'PEA' and must exist within PER_SPECIAL_INFO_TYPES
134: -- for the business group.
135: --
136: cursor ancsel is
137: select 1

Line 138: from per_special_info_types pc,

134: -- for the business group.
135: --
136: cursor ancsel is
137: select 1
138: from per_special_info_types pc,
139: fnd_id_flex_structures fs
140: where fs.id_flex_num = pc.id_flex_num
141: and fs.id_flex_code = 'PEA'
142: and pc.enabled_flag = 'Y'

Line 156: -- per_special_info_types

152: where fs.id_flex_num = p_id_flex_num
153: and fs.id_flex_code = 'PEA';
154: --
155: -- the cursor ancerrsel2 determines if the id_flex_num is valid for
156: -- per_special_info_types
157: -- note: only called when cursor ancsel fails
158: --
159: cursor ancerrsel2 is
160: select 1

Line 161: from per_special_info_types pc

157: -- note: only called when cursor ancsel fails
158: --
159: cursor ancerrsel2 is
160: select 1
161: from per_special_info_types pc
162: where pc.business_group_id + 0 = p_business_group_id
163: and pc.id_flex_num = p_id_flex_num;
164: --
165: -- the cursor c1 derives segment values using p_analysis_criteria_id

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

381: fetch ancerrsel2 into l_discard;
382: if ancerrsel2%notfound then
383: close ancerrsel2;
384: --
385: -- the row does not exist in PER_SPECIAL_INFO_TYPES
386: --
387: hr_utility.set_message(801, 'HR_51114_JBR_SPCIAL_NOT_EXIST');
388: hr_utility.raise_error;
389: end if;

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

388: hr_utility.raise_error;
389: end if;
390: close ancerrsel2;
391: --
392: -- the row is not enabled in PER_SPECIAL_INFO_TYPES
393: --
394: hr_utility.set_message(801, 'HR_51115_JBR_SPCIAL_NOT_ENABLE');
395: hr_utility.raise_error;
396: end if;

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

932: fetch c2 into l_id_flex_num;
933: if c2%NOTFOUND then
934: --
935: close c2;
936: -- the row is not enabled in PER_SPECIAL_INFO_TYPES
937: --
938: hr_utility.set_message(800, 'PER_52508_PEA_INV_FLEX');
939: hr_utility.raise_error;
940: --