APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 24: l_asg_ei_data per_assignment_extra_info%rowtype;

20: WHERE person_id = p_person_id
21: AND p_effective_date between effective_start_date AND effective_end_date;
22:
23: l_assignment_id per_assignments_f.assignment_id%type;
24: l_asg_ei_data per_assignment_extra_info%rowtype;
25: l_session ghr_history_api.g_session_var_type;
26: l_session1 ghr_history_api.g_session_var_type;
27: --End Bug 5923620
28:

Line 640: l_asg_ei_data per_assignment_extra_info%rowtype;

636: )
637: is
638:
639: l_per_ei_data per_people_extra_info%rowtype;
640: l_asg_ei_data per_assignment_extra_info%rowtype;
641: l_pos_ei_data per_position_extra_info%rowtype;
642: l_multiple_error_flag boolean;
643: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;
644: l_proc varchar2(72):= g_package || 'noa_spec_extra_info';