APPS.GHR_EHRI_DYNRPT dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 805: --per_assignment_extra_info.aei_information4%TYPE;

801: l_information_type ghr_pa_request_extra_info.information_type%TYPE;
802: l_rei ghr_pa_request_extra_info%ROWTYPE;
803: l_per_ei_grp1_data per_people_extra_info%rowtype;
804: l_appt_nte_date DATE;
805: --per_assignment_extra_info.aei_information4%TYPE;
806: --
807: CURSOR get_asg_id(p_request_id NUMBER,
808: p_person_id NUMBER)
809: IS

Line 816: l_asg_ei_data per_assignment_extra_info%rowtype;

812: WHERE pa_request_id=p_request_id
813: AND person_id=p_person_id;
814: --
815: l_asg_id per_assignments_f.assignment_id%TYPE;
816: l_asg_ei_data per_assignment_extra_info%rowtype;
817:
818: BEGIN
819: --
820: FOR get_asg_rec IN get_asg_id(p_pa_request_id, p_person_id)

Line 864: l_asgei_data per_assignment_extra_info%ROWTYPE;

860: --
861: l_pa_request_id NUMBER;
862: l_noa_id NUMBER;
863: --
864: l_asgei_data per_assignment_extra_info%ROWTYPE;
865: l_asgn_data per_all_assignments_f%ROWTYPE;
866: l_assignment_id NUMBER;
867: l_location_id NUMBER;
868: l_duty_station_id NUMBER;