APPS.GHR_SF52_PRE_UPDATE dependencies on PER_PERSON_TYPES

Line 171: from per_person_types ppt,

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

Line 255: l_person_type per_person_types.system_person_type%type;

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

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

808: l_per_extra_info_rec per_people_extra_info%rowtype;
809: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
810: l_pos_extra_info_rec per_position_extra_info%rowtype;
811: l_proc varchar2(70) := 'Retrieve_all_extra_info';
812: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;
813: l_position_id per_positions.position_id%type;
814: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
815: l_session ghr_history_api.g_session_var_type;
816: l_person_status per_assignment_status_types.user_status%type;

Line 824: from per_person_types ppt,

820: -- Cursor to retrieve the Person Type of the Person , as of the effective_date of the Request
821:
822: cursor c_person_type is
823: select ppt.system_person_type
824: from per_person_types ppt,
825: per_all_people_f ppf
826: where ppf.person_id = p_pa_request_rec.person_id
827: and ppt.person_type_id = ppf.person_type_id
828: and g_effective_date

Line 1752: l_person_type per_person_types.system_person_type%type;

1748: is
1749: --
1750: l_noa_code ghr_nature_of_actions.code%type;
1751: l_proc varchar2(70) := 'Process_Sf52_Extra_Info';
1752: l_person_type per_person_types.system_person_type%type;
1753:
1754: --
1755:
1756:

Line 1759: from per_person_types ppt,

1755:
1756:
1757: cursor c_person_type is
1758: select ppt.system_person_type
1759: from per_person_types ppt,
1760: per_all_people_f ppf
1761: where ppf.person_id = p_pa_request_rec.person_id
1762: and ppt.person_type_id = ppf.person_type_id
1763: and g_effective_date