APPS.GHR_PA_REQUESTS_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 342: FROM per_people_extra_info pei

338: ,pei.pei_information6 authorizer_flag
339: ,pei.pei_information7 personnelist_flag
340: ,pei.pei_information8 approver_flag
341: ,pei.pei_information9 reviewer_flag
342: FROM per_people_extra_info pei
343: ,fnd_user use
344: WHERE use.user_name = p_user_name
345: AND pei.person_id = use.employee_id
346: AND pei.information_type = 'GHR_US_PER_WF_ROUTING_GROUPS'

Line 524: from per_people_extra_info pei

520: ,pei.pei_information6 authorizer_flag
521: ,pei.pei_information7 personnelist_flag
522: ,pei.pei_information8 approver_flag
523: ,pei.pei_information9 reviewer_flag
524: from per_people_extra_info pei
525: ,fnd_user usr
526: where usr.user_name = l_user_name
527: and pei.person_id = usr.employee_id
528: and pei.information_type = 'GHR_US_PER_WF_ROUTING_GROUPS'

Line 722: l_per_ei_data per_people_extra_info%rowtype;

718:
719: -- Bug No 550117 Need seperate variable to store what is returned by the second
720: -- call to ghr_history_fetch.fetch_peopleei
721:
722: l_per_ei_data per_people_extra_info%rowtype;
723: l_per_ei_scd_data per_people_extra_info%rowtype;
724:
725: BEGIN
726:

Line 723: l_per_ei_scd_data per_people_extra_info%rowtype;

719: -- Bug No 550117 Need seperate variable to store what is returned by the second
720: -- call to ghr_history_fetch.fetch_peopleei
721:
722: l_per_ei_data per_people_extra_info%rowtype;
723: l_per_ei_scd_data per_people_extra_info%rowtype;
724:
725: BEGIN
726:
727: ghr_history_fetch.fetch_peopleei(

Line 1445: FROM per_people_extra_info pei

1441: l_ret_val VARCHAR2(30) := NULL;
1442: --
1443: CURSOR c_pei IS
1444: SELECT pei.pei_information3 restricted_form
1445: FROM per_people_extra_info pei
1446: WHERE pei.information_type = 'GHR_US_PER_USER_INFO'
1447: AND pei.person_id = p_person_id;
1448:
1449: BEGIN

Line 2093: l_per_ei_data per_people_extra_info%rowtype;

2089: IS
2090:
2091: l_effective_date DATE;
2092: l_update34_date DATE;
2093: l_per_ei_data per_people_extra_info%rowtype;
2094: l_person_extra_info_id NUMBER;
2095: l_object_version_number NUMBER;
2096:
2097: l_tenure VARCHAR2(150);

Line 2188: delete per_people_extra_info

2184: l_object_version_number := l_per_ei_data.object_version_number;
2185: if l_person_extra_info_id is not null then
2186: hr_utility.set_location('PEID Exists',1);
2187: if l_del_flag = 'Y' then
2188: delete per_people_extra_info
2189: where person_extra_info_id = l_person_extra_info_id;
2190:
2191: delete from ghr_pa_history
2192: where table_name = 'PER_PEOPLE_EXTRA_INFO'

Line 2192: where table_name = 'PER_PEOPLE_EXTRA_INFO'

2188: delete per_people_extra_info
2189: where person_extra_info_id = l_person_extra_info_id;
2190:
2191: delete from ghr_pa_history
2192: where table_name = 'PER_PEOPLE_EXTRA_INFO'
2193: and information1 = l_person_extra_info_id;
2194:
2195: end if;
2196:

Line 2199: where table_name = 'PER_PEOPLE_EXTRA_INFO'

2195: end if;
2196:
2197: if l_upd_flag = 'Y' then
2198: delete from ghr_pa_history
2199: where table_name = 'PER_PEOPLE_EXTRA_INFO'
2200: and to_number(information4) = p_person_id
2201: and information5 = 'GHR_US_PER_UPDATE34'
2202: and pa_request_id = l_altered_pa_request_id ;
2203: