APPS.PQP_HRTCA_SYNCHRONIZATION dependencies on PER_PEOPLE_EXTRA_INFO

Line 14: FROM per_people_extra_info pei

10: -- =============================================================================
11: -- Cursor to check if person is student
12: CURSOR csr_stu (c_person_id IN Number) IS
13: SELECT pei.pei_information5
14: FROM per_people_extra_info pei
15: WHERE pei.information_type = 'PQP_OSS_PERSON_DETAILS'
16: AND pei.pei_information_category = 'PQP_OSS_PERSON_DETAILS'
17: AND pei.person_id = c_person_id;
18:

Line 78: l_pei_rec per_people_extra_info%ROWTYPE;

74: l_party_id per_all_people_f.party_id%TYPE;
75: l_bg_code per_business_groups.legislation_code%TYPE;
76: l_Stu_OSSData_Sync Varchar2(5);
77:
78: l_pei_rec per_people_extra_info%ROWTYPE;
79: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Pei_DDF_Ins';
80:
81: BEGIN
82: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 256: l_pei_rec_new per_people_extra_info%ROWTYPE;

252: l_return_flag Boolean;
253: l_party_id per_all_people_f.party_id%TYPE;
254: l_Stu_OSSData_Sync Varchar2(5);
255: l_bg_code per_business_groups.legislation_code%TYPE;
256: l_pei_rec_new per_people_extra_info%ROWTYPE;
257: l_pei_rec_old per_people_extra_info%ROWTYPE;
258: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Pei_DDF_Upd';
259:
260: BEGIN

Line 257: l_pei_rec_old per_people_extra_info%ROWTYPE;

253: l_party_id per_all_people_f.party_id%TYPE;
254: l_Stu_OSSData_Sync Varchar2(5);
255: l_bg_code per_business_groups.legislation_code%TYPE;
256: l_pei_rec_new per_people_extra_info%ROWTYPE;
257: l_pei_rec_old per_people_extra_info%ROWTYPE;
258: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Pei_DDF_Upd';
259:
260: BEGIN
261: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 428: l_pei_rec per_people_extra_info%ROWTYPE;

424: ,p_pei_information28_o IN Varchar2
425: ,p_pei_information29_o IN Varchar2
426: ,p_pei_information30_o IN Varchar2
427: ) AS
428: l_pei_rec per_people_extra_info%ROWTYPE;
429: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Pei_DDF_Del';
430: BEGIN
431: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
432: NULL;