APPS.GHR_MASS_SEL_NOA dependencies on PER_PEOPLE_EXTRA_INFO

Line 130: l_per_ei_data per_people_extra_info%ROWTYPE;

126: , p_effective_date IN date) IS
127:
128: l_person_extra_info_id number;
129: l_object_version_number number;
130: l_per_ei_data per_people_extra_info%ROWTYPE;
131: l_proc varchar2(72) DEFAULT g_package|| '.update_sel_flg';
132: l_ind number DEFAULT 1;
133:
134: BEGIN

Line 187: l_per_ei_data per_people_extra_info%ROWTYPE;

183: , p_effective_date IN date
184: , p_mass_salary_id IN number
185: , p_sel_flg IN OUT NOCOPY varchar2) RETURN boolean IS
186:
187: l_per_ei_data per_people_extra_info%ROWTYPE;
188: l_comments varchar2(250);
189: l_sel_flag varchar2(3);
190: l_line number DEFAULT 0;
191: l_proc varchar2(72) DEFAULT g_package|| '.check_select_flg';

Line 246: l_per_ei_data per_people_extra_info%ROWTYPE;

242: , p_sel_flag IN OUT NOCOPY varchar2
243: , p_comments IN OUT NOCOPY varchar2
244: , p_mass_salary_id IN number) IS
245:
246: l_per_ei_data per_people_extra_info%ROWTYPE;
247: l_proc varchar2(72) DEFAULT g_package|| '.get_extra_info_comments';
248: l_eff_date date;
249: CURSOR chk_history
250: (p_person_id IN number

Line 264: AND table_name = 'PER_PEOPLE_EXTRA_INFO'

260: SELECT max (pa_history_id)
261: FROM ghr_pa_history
262: WHERE person_id = p_person_id
263: AND information5 = 'GHR_US_PER_MASS_ACTIONS'
264: AND table_name = 'PER_PEOPLE_EXTRA_INFO'
265: AND effective_date = eff_date
266: GROUP BY information11
267: );
268: BEGIN

Line 324: l_pei_extra_info per_people_extra_info%ROWTYPE;

320: l_pa_object_version_number number;
321: l_dummy varchar2(30);
322: l_information_type varchar2(40);
323: l_employment_type varchar2(5);
324: l_pei_extra_info per_people_extra_info%ROWTYPE;
325: l_pa_rei_id number;
326: l_rpa_eff_date date;
327: l_rpa_nte_date date;
328: --Bug# 14456039

Line 935: l_pei_extra_info per_people_extra_info%ROWTYPE;

931: l_cust_rec ghr_mass_act_custom.ghr_mass_custom_out_rec_type;
932: l_cust_in_rec ghr_mass_act_custom.ghr_mass_custom_in_rec_type;
933: l_poi_desc varchar2(80);
934: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
935: l_pei_extra_info per_people_extra_info%ROWTYPE;
936: l_old_assignment_status varchar2(80);
937: l_new_assignment_status varchar2(80);
938: l_old_type_of_employment varchar2(30);
939: l_new_type_of_employment varchar2(30);

Line 1328: l_per_ei_data per_people_extra_info%ROWTYPE;

1324: , p_msl_id IN number) IS
1325:
1326: l_person_extra_info_id number;
1327: l_object_version_number number;
1328: l_per_ei_data per_people_extra_info%ROWTYPE;
1329:
1330: CURSOR people_ext_cur
1331: (person IN number) IS
1332: SELECT person_extra_info_id

Line 1334: FROM per_people_extra_info

1330: CURSOR people_ext_cur
1331: (person IN number) IS
1332: SELECT person_extra_info_id
1333: , object_version_number
1334: FROM per_people_extra_info
1335: WHERE person_id = person
1336: AND information_type = 'GHR_US_PER_MASS_ACTIONS';
1337:
1338: l_proc varchar2(72) DEFAULT g_package|| '.ins_upd_per_extra_info';