APPS.GHR_CPDF_EHRIS dependencies on PER_ALL_PEOPLE

Line 243: per_all_people PER ,

239: CURSOR cur_per IS
240: SELECT
241: DECODE(PER.CURRENT_EMPLOYEE_FLAG, 'Y', PPS.DATE_START, DECODE(PER.CURRENT_NPW_FLAG, 'Y', PPP.DATE_START, NULL)) hire_date
242: FROM
243: per_all_people PER ,
244: PER_PERIODS_OF_SERVICE PPS ,
245: PER_PERIODS_OF_PLACEMENT PPP
246: WHERE
247: PPS.PERSON_ID (+) = PER.PERSON_ID AND

Line 337: FROM per_all_people

333: NATIONAL_IDENTIFIER,
334: EMPLOYEE_NUMBER,
335: EMAIL_ADDRESS
336:
337: FROM per_all_people
338: WHERE (TRUNC(p_sr_report_date) between effective_start_date
339: and effective_end_date)
340: AND PERSON_ID = g_person_id;
341:

Line 346: WHERE pho.parent_table = 'PER_ALL_PEOPLE_F'

342: -- JH New EHRI Phones
343: CURSOR cur_phones IS
344: SELECT pho.phone_number, pho.phone_type
345: FROM per_phones pho
346: WHERE pho.parent_table = 'PER_ALL_PEOPLE_F'
347: AND pho.parent_id = g_person_id
348: AND pho.phone_type IN ('W1','H1','M');
349:
350: -- JH EHRI Get Emergeny Contacts

Line 355: ,per_all_people contact

351: CURSOR cur_contacts IS
352: SELECT contact.last_name, contact.first_name, contact.middle_names, contact.suffix
353: ,pho.phone_number, rel.date_start
354: FROM per_contact_relationships_v2 rel
355: ,per_all_people contact
356: ,per_phones pho
357: WHERE rel.person_id = g_person_id
358: AND contact_type in ('EMRG','EC')
359: AND rel.contact_person_id = contact.person_id

Line 388: l_last_name per_all_people.last_name%type;

384: l_PEOPLE_REC PEOPLE_CUR%ROWTYPE;
385: l_contact_cnt INTEGER;
386: l_cnt NUMBER := 0;
387: l_suffix GHR_CPDF_TEMP.emrgncy_cntct_suffix1%TYPE;
388: l_last_name per_all_people.last_name%type;
389:
390:
391: BEGIN
392: hr_utility.set_location('Entering:'||l_proc,5);

Line 481: l_emp_number per_all_people.employee_number%TYPE;

477: )
478: IS
479: l_proc varchar2(30) := 'get_from_history_ancrit';
480: l_ANCRIT_REC ghr_api.special_information_type;
481: l_emp_number per_all_people.employee_number%TYPE;
482:
483: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
484: l_max_segment per_analysis_criteria.segment1%type;
485: l_lang_cnt number;

Line 494: FROM per_all_people per

490: l_log_text varchar2(2000);
491:
492: CURSOR c_per IS
493: SELECT per.employee_number
494: FROM per_all_people per
495: WHERE per.person_id = p_sr_person_id
496: AND NVL(p_sr_report_date, TRUNC(sysdate)) BETWEEN per.effective_start_date
497: AND per.effective_end_date;
498:

Line 3403: CURSOR cur_per_details(p_person_id per_all_people.person_id%type)

3399: l_log_text ghr_process_log.log_text%type;
3400: l_message_name ghr_process_log.message_name%type;
3401: l_log_date ghr_process_log.log_date%type;
3402:
3403: CURSOR cur_per_details(p_person_id per_all_people.person_id%type)
3404: IS
3405: --bug # 9329643 added employee number
3406: SELECT pap.full_name name ,pap.national_identifier ssn,pap.last_name,pap.first_name
3407: ,pap.middle_names, pap.title, pap.employee_number

Line 3408: FROM per_all_people pap

3404: IS
3405: --bug # 9329643 added employee number
3406: SELECT pap.full_name name ,pap.national_identifier ssn,pap.last_name,pap.first_name
3407: ,pap.middle_names, pap.title, pap.employee_number
3408: FROM per_all_people pap
3409: WHERE p_person_id = pap.person_id
3410: AND p_report_date between pap.effective_start_date AND pap.effective_end_date
3411: AND g_business_group_id = pap.business_group_id;
3412:

Line 3447: l_full_name per_all_people.full_name%type;

3443: --Bug# 6158983
3444:
3445:
3446:
3447: l_full_name per_all_people.full_name%type;
3448: l_ssn per_all_people.national_identifier%type;
3449: l_records_found BOOLEAN;
3450: l_mesgbuff1 VARCHAR2(4000);
3451: l_assignment_status_type VARCHAR2(200);

Line 3448: l_ssn per_all_people.national_identifier%type;

3444:
3445:
3446:
3447: l_full_name per_all_people.full_name%type;
3448: l_ssn per_all_people.national_identifier%type;
3449: l_records_found BOOLEAN;
3450: l_mesgbuff1 VARCHAR2(4000);
3451: l_assignment_status_type VARCHAR2(200);
3452: l_suffix VARCHAR2(30) := NULL;