78: p_effective_date date) is
79:
80: cursor cur_pei_id is
81: select person_extra_info_id, object_version_number
82: from per_people_extra_info
83: where person_id = p_person_id
84: and information_type = 'GHR_US_PER_MASS_ACTIONS';
85:
86: l_person_extra_info_id per_people_extra_info.person_extra_info_id%type;
82: from per_people_extra_info
83: where person_id = p_person_id
84: and information_type = 'GHR_US_PER_MASS_ACTIONS';
85:
86: l_person_extra_info_id per_people_extra_info.person_extra_info_id%type;
87: l_object_version_number per_people_extra_info.object_version_number%type;
88:
89: l_proc varchar2(72) := g_package||'update_mass_transfer_in_flag';
90:
83: where person_id = p_person_id
84: and information_type = 'GHR_US_PER_MASS_ACTIONS';
85:
86: l_person_extra_info_id per_people_extra_info.person_extra_info_id%type;
87: l_object_version_number per_people_extra_info.object_version_number%type;
88:
89: l_proc varchar2(72) := g_package||'update_mass_transfer_in_flag';
90:
91: begin