APPS.GHR_SF52_PRE_UPDATE dependencies on PER_PERSON_TYPES

Line 168: from per_person_types ppt,

164: -- specific NOA and hence should be available already in the passed parameter.
165:
166: cursor c_person_type is
167: select ppt.system_person_type
168: from per_person_types ppt,
169: per_all_people_f ppf
170: where ppf.person_id = p_pa_request_rec.person_id
171: and ppt.person_type_id = ppf.person_type_id
172: and p_pa_request_rec.effective_date

Line 251: l_person_type per_person_types.system_person_type%type;

247: l_session ghr_history_api.g_session_var_type;
248: l_asg_ei_data per_assignment_extra_info%rowtype;
249: l_assignment_data per_all_assignments_f%rowtype;
250: l_result_code varchar2(50);
251: l_person_type per_person_types.system_person_type%type;
252: l_effective_date date;
253: -- Bug#4054110
254: l_temp_rec_level varchar2(30);
255: --Pradeep

Line 792: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;

788: l_per_extra_info_rec per_people_extra_info%rowtype;
789: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
790: l_pos_extra_info_rec per_position_extra_info%rowtype;
791: l_proc varchar2(70) := 'Retrieve_all_extra_info';
792: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;
793: l_position_id per_positions.position_id%type;
794: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
795: l_session ghr_history_api.g_session_var_type;
796: l_person_status per_assignment_status_types.user_status%type;

Line 804: from per_person_types ppt,

800: -- Cursor to retrieve the Person Type of the Person , as of the effective_date of the Request
801:
802: cursor c_person_type is
803: select ppt.system_person_type
804: from per_person_types ppt,
805: per_all_people_f ppf
806: where ppf.person_id = p_pa_request_rec.person_id
807: and ppt.person_type_id = ppf.person_type_id
808: and g_effective_date

Line 1653: l_person_type per_person_types.system_person_type%type;

1649: is
1650: --
1651: l_noa_code ghr_nature_of_actions.code%type;
1652: l_proc varchar2(70) := 'Process_Sf52_Extra_Info';
1653: l_person_type per_person_types.system_person_type%type;
1654:
1655: --
1656:
1657:

Line 1660: from per_person_types ppt,

1656:
1657:
1658: cursor c_person_type is
1659: select ppt.system_person_type
1660: from per_person_types ppt,
1661: per_all_people_f ppf
1662: where ppf.person_id = p_pa_request_rec.person_id
1663: and ppt.person_type_id = ppf.person_type_id
1664: and g_effective_date