APPS.GHR_API dependencies on PER_ANALYSIS_CRITERIA

Line 3649: l_max_segment per_analysis_criteria.segment1%type;

3645: )
3646: is
3647: l_proc varchar2(72) := 'return_special_information ';
3648: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
3649: l_max_segment per_analysis_criteria.segment1%type;
3650:
3651: Cursor c_flex_num is
3652: select flx.id_flex_num
3653: from fnd_id_flex_structures_tl flx

Line 3695: from per_analysis_Criteria pea,

3691: pea.segment27,
3692: pea.segment28,
3693: pea.segment29,
3694: pea.segment30
3695: from per_analysis_Criteria pea,
3696: per_person_analyses pan
3697: where pan.person_id = p_person_id
3698: and pan.id_flex_num = l_id_flex_num
3699: and pea.analysis_Criteria_id = pan.analysis_criteria_id

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

3767:
3768: Procedure return_education_Details
3769: (p_person_id in per_people_f.person_id%type,
3770: p_effective_date in date,
3771: p_education_level OUT NOCOPY per_analysis_criteria.segment1%type,
3772: p_academic_discipline OUT NOCOPY per_analysis_criteria.segment2%type,
3773: p_year_degree_attained OUT NOCOPY per_analysis_criteria.segment3%type
3774: )
3775: is

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

3768: Procedure return_education_Details
3769: (p_person_id in per_people_f.person_id%type,
3770: p_effective_date in date,
3771: p_education_level OUT NOCOPY per_analysis_criteria.segment1%type,
3772: p_academic_discipline OUT NOCOPY per_analysis_criteria.segment2%type,
3773: p_year_degree_attained OUT NOCOPY per_analysis_criteria.segment3%type
3774: )
3775: is
3776:

Line 3773: p_year_degree_attained OUT NOCOPY per_analysis_criteria.segment3%type

3769: (p_person_id in per_people_f.person_id%type,
3770: p_effective_date in date,
3771: p_education_level OUT NOCOPY per_analysis_criteria.segment1%type,
3772: p_academic_discipline OUT NOCOPY per_analysis_criteria.segment2%type,
3773: p_year_degree_attained OUT NOCOPY per_analysis_criteria.segment3%type
3774: )
3775: is
3776:
3777: l_proc varchar2(72) := 'return_education_Details';

Line 3813: from per_analysis_criteria pea,

3809: pea.segment17,
3810: pea.segment18,
3811: pea.segment19,
3812: pea.segment20
3813: from per_analysis_criteria pea,
3814: per_person_analyses pan
3815: where pan.person_id = p_person_id
3816: and pan.id_flex_num = l_id_flex_num
3817: and pea.id_flex_num = pan.id_flex_num