APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 32: l_asg_ei_data per_assignment_extra_info%rowtype;

28: WHERE person_id = p_person_id
29: AND p_effective_date between effective_start_date AND effective_end_date;
30:
31: l_assignment_id per_assignments_f.assignment_id%type;
32: l_asg_ei_data per_assignment_extra_info%rowtype;
33: l_session ghr_history_api.g_session_var_type;
34: l_session1 ghr_history_api.g_session_var_type;
35: --End Bug 5923620
36:

Line 699: l_asg_ei_data per_assignment_extra_info%rowtype;

695: )
696: is
697:
698: l_per_ei_data per_people_extra_info%rowtype;
699: l_asg_ei_data per_assignment_extra_info%rowtype;
700: l_pos_ei_data per_position_extra_info%rowtype;
701: l_multiple_error_flag boolean;
702: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;
703: l_proc varchar2(72):= g_package || 'noa_spec_extra_info';