APPS.GHR_SF52_DO_UPDATE dependencies on PER_PERSON_ANALYSES

Line 1014: l_personal_analysis_id per_person_analyses.person_analysis_id%type;

1010: l_proc varchar2(72) := 'Generic Sit';
1011: l_business_group_id per_people_f.business_group_id%type;
1012: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
1013: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
1014: l_personal_analysis_id per_person_analyses.person_analysis_id%type;
1015: l_education_level ghr_pa_requests.education_level%type;
1016: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
1017: l_academic_discipline ghr_pa_requests.academic_discipline%type;
1018: l_object_version_number number(9);

Line 1041: from per_person_analyses

1037: Cursor c_person_sit is
1038: select analysis_criteria_id ,
1039: person_analysis_id ,
1040: object_version_number
1041: from per_person_analyses
1042: where person_id = p_pa_request_rec.person_id
1043: and id_flex_num = l_id_flex_num;
1044:
1045: -- Cursor to return the record with the highest education level (segment1) for the person for the specific id_flex_num

Line 1055: per_person_analyses pan

1051: pea.segment3 year_degree_attained,
1052: pan.person_analysis_id,
1053: pan.object_version_number
1054: from per_analysis_criteria pea,
1055: per_person_analyses pan
1056: where pan.person_id = p_pa_request_rec.person_id
1057: and pan.id_flex_num = l_id_flex_num
1058: and pea.id_flex_num = pan.id_flex_num
1059: and p_pa_request_rec.effective_date

Line 8218: l_person_analysis_id per_person_analyses.person_analysis_id%type;

8214: l_object_version_number per_people_f.object_version_number%type;
8215: l_session ghr_history_api.g_session_var_type;
8216: l_multiple varchar2(1);
8217: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
8218: l_person_analysis_id per_person_analyses.person_analysis_id%type;
8219: l_business_group_id per_people_f.business_group_id%type;
8220: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
8221: -- Bug#4054110,4069798 Added l_date_from variable
8222: l_date_from DATE;

Line 8247: from per_person_analyses

8243: -- Bug#4054110,4069798 Added cursor c_date_from to fetch the
8244: -- start date of SIT record.
8245: Cursor c_date_from is
8246: Select date_from
8247: from per_person_analyses
8248: where person_analysis_id = p_segment_rec.person_analysis_id;
8249:
8250: BEGIN
8251: