APPS.GHR_API dependencies on PER_ANALYSIS_CRITERIA

Line 3642: l_max_segment per_analysis_criteria.segment1%type;

3638: )
3639: is
3640: l_proc varchar2(72) := 'return_special_information ';
3641: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
3642: l_max_segment per_analysis_criteria.segment1%type;
3643:
3644: Cursor c_flex_num is
3645: select flx.id_flex_num
3646: from fnd_id_flex_structures_tl flx

Line 3688: from per_analysis_Criteria pea,

3684: pea.segment27,
3685: pea.segment28,
3686: pea.segment29,
3687: pea.segment30
3688: from per_analysis_Criteria pea,
3689: per_person_analyses pan
3690: where pan.person_id = p_person_id
3691: and pan.id_flex_num = l_id_flex_num
3692: and pea.analysis_Criteria_id = pan.analysis_criteria_id

Line 3764: p_education_level OUT NOCOPY per_analysis_criteria.segment1%type,

3760:
3761: Procedure return_education_Details
3762: (p_person_id in per_people_f.person_id%type,
3763: p_effective_date in date,
3764: p_education_level OUT NOCOPY per_analysis_criteria.segment1%type,
3765: p_academic_discipline OUT NOCOPY per_analysis_criteria.segment2%type,
3766: p_year_degree_attained OUT NOCOPY per_analysis_criteria.segment3%type
3767: )
3768: is

Line 3765: p_academic_discipline OUT NOCOPY per_analysis_criteria.segment2%type,

3761: Procedure return_education_Details
3762: (p_person_id in per_people_f.person_id%type,
3763: p_effective_date in date,
3764: p_education_level OUT NOCOPY per_analysis_criteria.segment1%type,
3765: p_academic_discipline OUT NOCOPY per_analysis_criteria.segment2%type,
3766: p_year_degree_attained OUT NOCOPY per_analysis_criteria.segment3%type
3767: )
3768: is
3769:

Line 3766: p_year_degree_attained OUT NOCOPY per_analysis_criteria.segment3%type

3762: (p_person_id in per_people_f.person_id%type,
3763: p_effective_date in date,
3764: p_education_level OUT NOCOPY per_analysis_criteria.segment1%type,
3765: p_academic_discipline OUT NOCOPY per_analysis_criteria.segment2%type,
3766: p_year_degree_attained OUT NOCOPY per_analysis_criteria.segment3%type
3767: )
3768: is
3769:
3770: l_proc varchar2(72) := 'return_education_Details';

Line 3806: from per_analysis_criteria pea,

3802: pea.segment17,
3803: pea.segment18,
3804: pea.segment19,
3805: pea.segment20
3806: from per_analysis_criteria pea,
3807: per_person_analyses pan
3808: where pan.person_id = p_person_id
3809: and pan.id_flex_num = l_id_flex_num
3810: and pea.id_flex_num = pan.id_flex_num