APPS.GHR_SF52_DO_UPDATE dependencies on PER_PERSON_ANALYSES

Line 1029: l_personal_analysis_id per_person_analyses.person_analysis_id%type;

1025: l_proc varchar2(72) := 'Generic Sit';
1026: l_business_group_id per_people_f.business_group_id%type;
1027: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
1028: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
1029: l_personal_analysis_id per_person_analyses.person_analysis_id%type;
1030: l_education_level ghr_pa_requests.education_level%type;
1031: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
1032: l_academic_discipline ghr_pa_requests.academic_discipline%type;
1033: l_object_version_number number(9);

Line 1056: from per_person_analyses

1052: Cursor c_person_sit is
1053: select analysis_criteria_id ,
1054: person_analysis_id ,
1055: object_version_number
1056: from per_person_analyses
1057: where person_id = p_pa_request_rec.person_id
1058: and id_flex_num = l_id_flex_num;
1059:
1060: -- Cursor to return the record with the highest education level (segment1) for the person for the specific id_flex_num

Line 1070: per_person_analyses pan

1066: pea.segment3 year_degree_attained,
1067: pan.person_analysis_id,
1068: pan.object_version_number
1069: from per_analysis_criteria pea,
1070: per_person_analyses pan
1071: where pan.person_id = p_pa_request_rec.person_id
1072: and pan.id_flex_num = l_id_flex_num
1073: and pea.id_flex_num = pan.id_flex_num
1074: and p_pa_request_rec.effective_date

Line 8521: l_person_analysis_id per_person_analyses.person_analysis_id%type;

8517: l_object_version_number per_people_f.object_version_number%type;
8518: l_session ghr_history_api.g_session_var_type;
8519: l_multiple varchar2(1);
8520: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
8521: l_person_analysis_id per_person_analyses.person_analysis_id%type;
8522: l_business_group_id per_people_f.business_group_id%type;
8523: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
8524: -- Bug#4054110,4069798 Added l_date_from variable
8525: l_date_from DATE;

Line 8550: from per_person_analyses

8546: -- Bug#4054110,4069798 Added cursor c_date_from to fetch the
8547: -- start date of SIT record.
8548: Cursor c_date_from is
8549: Select date_from
8550: from per_person_analyses
8551: where person_analysis_id = p_segment_rec.person_analysis_id;
8552:
8553: BEGIN
8554: