APPS.GHR_CPDF_EHRIS dependencies on PER_ALL_PEOPLE

Line 242: per_all_people PER ,

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

Line 325: FROM per_all_people

321: NATIONAL_IDENTIFIER,
322: EMPLOYEE_NUMBER,
323: EMAIL_ADDRESS
324:
325: FROM per_all_people
326: WHERE (TRUNC(p_sr_report_date) between effective_start_date
327: and effective_end_date)
328: AND PERSON_ID = g_person_id;
329:

Line 334: WHERE pho.parent_table = 'PER_ALL_PEOPLE_F'

330: -- JH New EHRI Phones
331: CURSOR cur_phones IS
332: SELECT pho.phone_number, pho.phone_type
333: FROM per_phones pho
334: WHERE pho.parent_table = 'PER_ALL_PEOPLE_F'
335: AND pho.parent_id = g_person_id
336: AND pho.phone_type IN ('W1','H1','M');
337:
338: -- JH EHRI Get Emergeny Contacts

Line 343: ,per_all_people contact

339: CURSOR cur_contacts IS
340: SELECT contact.last_name, contact.first_name, contact.middle_names, contact.suffix
341: ,pho.phone_number, rel.date_start
342: FROM per_contact_relationships_v2 rel
343: ,per_all_people contact
344: ,per_phones pho
345: WHERE rel.person_id = g_person_id
346: AND contact_type in ('EMRG','EC')
347: AND rel.contact_person_id = contact.person_id

Line 376: l_last_name per_all_people.last_name%type;

372: l_PEOPLE_REC PEOPLE_CUR%ROWTYPE;
373: l_contact_cnt INTEGER;
374: l_cnt NUMBER := 0;
375: l_suffix GHR_CPDF_TEMP.emrgncy_cntct_suffix1%TYPE;
376: l_last_name per_all_people.last_name%type;
377:
378:
379: BEGIN
380: hr_utility.set_location('Entering:'||l_proc,5);

Line 468: l_emp_number per_all_people.employee_number%TYPE;

464: )
465: IS
466: l_proc varchar2(30) := 'get_from_history_ancrit';
467: l_ANCRIT_REC ghr_api.special_information_type;
468: l_emp_number per_all_people.employee_number%TYPE;
469:
470: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
471: l_max_segment per_analysis_criteria.segment1%type;
472: l_lang_cnt number;

Line 481: FROM per_all_people per

477: l_log_text varchar2(2000);
478:
479: CURSOR c_per IS
480: SELECT per.employee_number
481: FROM per_all_people per
482: WHERE per.person_id = p_sr_person_id
483: AND NVL(p_sr_report_date, TRUNC(sysdate)) BETWEEN per.effective_start_date
484: AND per.effective_end_date;
485:

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

3259: l_log_text ghr_process_log.log_text%type;
3260: l_message_name ghr_process_log.message_name%type;
3261: l_log_date ghr_process_log.log_date%type;
3262:
3263: CURSOR cur_per_details(p_person_id per_all_people.person_id%type)
3264: IS
3265: SELECT pap.full_name name ,pap.national_identifier ssn,pap.last_name,pap.first_name
3266: ,pap.middle_names, pap.title
3267: FROM per_all_people pap

Line 3267: FROM per_all_people pap

3263: CURSOR cur_per_details(p_person_id per_all_people.person_id%type)
3264: IS
3265: SELECT pap.full_name name ,pap.national_identifier ssn,pap.last_name,pap.first_name
3266: ,pap.middle_names, pap.title
3267: FROM per_all_people pap
3268: WHERE p_person_id = pap.person_id
3269: AND p_report_date between pap.effective_start_date AND pap.effective_end_date
3270: AND g_business_group_id = pap.business_group_id;
3271:

Line 3306: l_full_name per_all_people.full_name%type;

3302: --Bug# 6158983
3303:
3304:
3305:
3306: l_full_name per_all_people.full_name%type;
3307: l_ssn per_all_people.national_identifier%type;
3308: l_records_found BOOLEAN;
3309: l_mesgbuff1 VARCHAR2(4000);
3310: l_assignment_status_type VARCHAR2(200);

Line 3307: l_ssn per_all_people.national_identifier%type;

3303:
3304:
3305:
3306: l_full_name per_all_people.full_name%type;
3307: l_ssn per_all_people.national_identifier%type;
3308: l_records_found BOOLEAN;
3309: l_mesgbuff1 VARCHAR2(4000);
3310: l_assignment_status_type VARCHAR2(200);
3311: l_suffix VARCHAR2(30) := NULL;