APPS.GHR_MTO_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 2864: l_per_ei_data per_people_extra_info%rowtype;

2860: PROCEDURE get_to_agency (p_person_id in number,
2861: p_effective_date in date,
2862: p_agency_code out NOCOPY varchar2) is
2863:
2864: l_per_ei_data per_people_extra_info%rowtype;
2865: l_proc varchar2(72) := g_package || '.upd_ext_info_api';
2866: l_eff_date date;
2867: l_agency_code varchar2(5);
2868: begin

Line 2906: from per_people_extra_info

2902: -- VSM - Changes Bug # 752015 changed p_information type from
2903: -- GHR_US_PER_SEPARATE_RETIRE to GHR_US_PER_MASS_ACTIONS
2904: CURSOR PERSON_EXT_CUR (p_person number) IS
2905: select person_extra_info_id, object_version_number
2906: from per_people_extra_info
2907: where person_id = (p_person)
2908: and INFORMATION_TYPE = 'GHR_US_PER_MASS_ACTIONS';
2909:
2910: l_cnt number;

Line 2916: l_per_ei_data per_people_extra_info%rowtype;

2912: l_person_EXTRA_INFO_ID NUMBER;
2913: l_OBJECT_VERSION_NUMBER NUMBER;
2914: l_object_version_no number;
2915:
2916: l_per_ei_data per_people_extra_info%rowtype;
2917: l_proc varchar2(72) := g_package || '.upd_ext_info_api';
2918: l_eff_date date;
2919:
2920: BEGIN

Line 3022: from per_people_extra_info

3018: Procedure upd_per_extra_info_to_null(p_person_id in number) is
3019:
3020: CURSOR PER_EXT_CUR (p_person number) IS
3021: select person_extra_info_id, object_version_number
3022: from per_people_extra_info
3023: where person_id = (p_person)
3024: and INFORMATION_TYPE = 'GHR_US_PER_MASS_ACTIONS';
3025:
3026: l_Person_EXTRA_INFO_ID NUMBER;

Line 3028: l_per_ei_data per_people_extra_info%rowtype;

3024: and INFORMATION_TYPE = 'GHR_US_PER_MASS_ACTIONS';
3025:
3026: l_Person_EXTRA_INFO_ID NUMBER;
3027: l_OBJECT_VERSION_NUMBER NUMBER;
3028: l_per_ei_data per_people_extra_info%rowtype;
3029: l_proc varchar2(72) := g_package || '.upd_per_extra_info_to_null';
3030: begin
3031:
3032: g_proc := 'upd_per_extra_info_to_null';