APPS.PER_PEA_BUS dependencies on PER_ANALYSIS_CRITERIA

Line 176: -- ID_FLEX_NUM in the PER_ANALYSIS_CRITERIA table for the record specified by

172: --
173: -- Validates that ANALYSIS_CRITERIA_ID is not null
174: --
175: -- Validates that ID_FLEX_NUM in the PER_PERSON_ANALYSES table matches the
176: -- ID_FLEX_NUM in the PER_ANALYSIS_CRITERIA table for the record specified by
177: -- ANALYSIS_CRITERIA_ID.
178: --
179: -- Pre-conditions:
180: -- ID_FLEX_NUM is not null.

Line 218: from per_analysis_criteria pac

214: -- the ID_FLEX_NUM for the other validation checks
215: --
216: cursor csr_valid_analysis_criteria_id is
217: select pac.id_flex_num
218: from per_analysis_criteria pac
219: where pac.analysis_criteria_id = p_analysis_criteria_id;
220: --
221: begin
222: hr_utility.set_location('Entering:'||l_proc,5);

Line 330: ,per_analysis_criteria ac

326: --
327: cursor c is
328: select 'x'
329: from per_person_analyses pa
330: ,per_analysis_criteria ac
331: where pa.analysis_criteria_id = p_analysis_criteria_id
332: and pa.business_group_id + 0 = p_bg_id
333: and pa.analysis_criteria_id = ac.analysis_criteria_id
334: and ac.id_flex_num = p_id_flex_num