APPS.GHR_EHRI_DYNRPT dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 801: --per_assignment_extra_info.aei_information4%TYPE;

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

Line 812: l_asg_ei_data per_assignment_extra_info%rowtype;

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

Line 860: l_asgei_data per_assignment_extra_info%ROWTYPE;

856: --
857: l_pa_request_id NUMBER;
858: l_noa_id NUMBER;
859: --
860: l_asgei_data per_assignment_extra_info%ROWTYPE;
861: l_asgn_data per_all_assignments_f%ROWTYPE;
862: l_assignment_id NUMBER;
863: l_location_id NUMBER;
864: l_duty_station_id NUMBER;