APPS.PER_PERSON_ANALYSES_PKG dependencies on PER_ANALYSIS_CRITERIA

Line 35: , per_analysis_criteria ac

31: ,p_rowid varchar2) is
32: cursor c is
33: select 'x'
34: from per_person_analyses pa
35: , per_analysis_criteria ac
36: where pa.analysis_criteria_id = p_analysis_criteria_id
37: and pa.business_group_id + 0 = p_bg_id
38: and pa.analysis_criteria_id = ac.analysis_criteria_id
39: and ac.id_flex_num = p_id_flex_num

Line 129: per_analysis_criteria ac

125: --
126: cursor c_duplicate_case is
127: select 'X'
128: from per_person_analyses pa,
129: per_analysis_criteria ac
130: where pa.business_group_id + 0 = p_business_group_id
131: and pa.analysis_criteria_id = ac.analysis_criteria_id
132: and ac.id_flex_num = p_id_flex_num
133: and ac.segment1 = p_segment1;

Line 182: -- where clause to check the id_flex_num in per_analysis_criteria table

178: , p_business_group_id in per_person_analyses.business_group_id%TYPE
179: ) RETURN VARCHAR2 IS
180: --
181: -- Bug fix 2863766
182: -- where clause to check the id_flex_num in per_analysis_criteria table
183: -- added to the cursor c_ppa.
184: cursor c_ppa is
185: select 'Y'
186: from per_person_analyses ppa,per_analysis_criteria pac

Line 186: from per_person_analyses ppa,per_analysis_criteria pac

182: -- where clause to check the id_flex_num in per_analysis_criteria table
183: -- added to the cursor c_ppa.
184: cursor c_ppa is
185: select 'Y'
186: from per_person_analyses ppa,per_analysis_criteria pac
187: where ppa.id_flex_num = p_id_flex_num
188: and ppa.person_id = p_person_id
189: and ppa.business_group_id = p_business_group_id
190: and pac.analysis_criteria_id = ppa.analysis_criteria_id