APPS.GHR_BREAKDOWN_RPT dependencies on PER_ANALYSIS_CRITERIA

Line 208: l_max_segment per_analysis_criteria.segment1%type;

204: )
205: is
206: l_proc varchar2(72) := 'return_special_information ';
207: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
208: l_max_segment per_analysis_criteria.segment1%type;
209:
210: Cursor c_flex_num is
211: select flx.id_flex_num
212: from fnd_id_flex_structures_tl flx

Line 242: from per_analysis_Criteria pea,

238: pea.segment17,
239: pea.segment18,
240: pea.segment19,
241: pea.segment20
242: from per_analysis_Criteria pea,
243: per_person_analyses pan
244: where pan.person_id = p_person_id
245: and pan.id_flex_num = l_id_flex_num
246: and pea.analysis_Criteria_id = pan.analysis_criteria_id