eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_HRHD_INITIAL_LOAD dependencies on PER_ALL_PEOPLE_F

Line 298: (select employee_number from per_all_people_f ppf,hr_organization_information hrorg1

294: TL.LANGUAGE,
295: TL.NAME,
296: ORG.LOCATION_ID,
297: /*Fix for 7576511 - to fetch employee number*/
298: (select employee_number from per_all_people_f ppf,hr_organization_information hrorg1
299: where ppf.person_id = hrorg1.ORG_INFORMATION2
300: and ppf.business_group_id = org.business_group_id
301: and hrorg1.org_information_context = 'Organization Name Alias'
302: and hrorg1.organization_id = org.organization_id

Line 322: (select employee_number from per_all_people_f ppf,hr_organization_information hrorg1

318: TL.LANGUAGE,
319: TL.NAME,
320: ORG.LOCATION_ID,
321: /*Fix for 7576511 - to fetch employee number*/
322: (select employee_number from per_all_people_f ppf,hr_organization_information hrorg1
323: where ppf.person_id = hrorg1.ORG_INFORMATION2
324: and ppf.business_group_id = org.business_group_id
325: and hrorg1.org_information_context = 'Organization Name Alias'
326: and hrorg1.organization_id = org.organization_id

Line 393: p_person_id per_all_people_f.person_id%type;

389: ,retcode OUT NOCOPY VARCHAR2)
390: IS
391:
392:
393: p_person_id per_all_people_f.person_id%type;
394: p_assignment_id per_all_assignments_f.assignment_id%type;
395: p_assignment_number per_all_assignments_f.assignment_number%type;
396: p_effective_start_date varchar2(10);
397: p_effective_end_date varchar2(10);

Line 523: p_person_id per_all_people_f.person_id%type;

519: PROCEDURE HR_PERSON_INITIAL_LOAD(errbuf OUT NOCOPY VARCHAR2
520: ,retcode OUT NOCOPY VARCHAR2)
521: IS
522:
523: p_person_id per_all_people_f.person_id%type;
524: p_business_group_id per_all_people_f.business_group_id%type;
525: p_legislation_code hr_organization_information.org_information9%type;
526: p_employee_number per_all_people_f.employee_number%type;
527: p_applicant_number per_all_people_f.applicant_number%type;

Line 524: p_business_group_id per_all_people_f.business_group_id%type;

520: ,retcode OUT NOCOPY VARCHAR2)
521: IS
522:
523: p_person_id per_all_people_f.person_id%type;
524: p_business_group_id per_all_people_f.business_group_id%type;
525: p_legislation_code hr_organization_information.org_information9%type;
526: p_employee_number per_all_people_f.employee_number%type;
527: p_applicant_number per_all_people_f.applicant_number%type;
528: p_npw_number per_all_people_f.npw_number%type;

Line 526: p_employee_number per_all_people_f.employee_number%type;

522:
523: p_person_id per_all_people_f.person_id%type;
524: p_business_group_id per_all_people_f.business_group_id%type;
525: p_legislation_code hr_organization_information.org_information9%type;
526: p_employee_number per_all_people_f.employee_number%type;
527: p_applicant_number per_all_people_f.applicant_number%type;
528: p_npw_number per_all_people_f.npw_number%type;
529: p_person_type_id per_all_people_f.person_type_id%type;
530: p_date_of_birth varchar2(10);

Line 527: p_applicant_number per_all_people_f.applicant_number%type;

523: p_person_id per_all_people_f.person_id%type;
524: p_business_group_id per_all_people_f.business_group_id%type;
525: p_legislation_code hr_organization_information.org_information9%type;
526: p_employee_number per_all_people_f.employee_number%type;
527: p_applicant_number per_all_people_f.applicant_number%type;
528: p_npw_number per_all_people_f.npw_number%type;
529: p_person_type_id per_all_people_f.person_type_id%type;
530: p_date_of_birth varchar2(10);
531: p_town_of_birth per_all_people_f.town_of_birth%type;

Line 528: p_npw_number per_all_people_f.npw_number%type;

524: p_business_group_id per_all_people_f.business_group_id%type;
525: p_legislation_code hr_organization_information.org_information9%type;
526: p_employee_number per_all_people_f.employee_number%type;
527: p_applicant_number per_all_people_f.applicant_number%type;
528: p_npw_number per_all_people_f.npw_number%type;
529: p_person_type_id per_all_people_f.person_type_id%type;
530: p_date_of_birth varchar2(10);
531: p_town_of_birth per_all_people_f.town_of_birth%type;
532: p_cntry_of_birth per_all_people_f.country_of_birth%type;

Line 529: p_person_type_id per_all_people_f.person_type_id%type;

525: p_legislation_code hr_organization_information.org_information9%type;
526: p_employee_number per_all_people_f.employee_number%type;
527: p_applicant_number per_all_people_f.applicant_number%type;
528: p_npw_number per_all_people_f.npw_number%type;
529: p_person_type_id per_all_people_f.person_type_id%type;
530: p_date_of_birth varchar2(10);
531: p_town_of_birth per_all_people_f.town_of_birth%type;
532: p_cntry_of_birth per_all_people_f.country_of_birth%type;
533: p_date_of_death varchar2(10);

Line 531: p_town_of_birth per_all_people_f.town_of_birth%type;

527: p_applicant_number per_all_people_f.applicant_number%type;
528: p_npw_number per_all_people_f.npw_number%type;
529: p_person_type_id per_all_people_f.person_type_id%type;
530: p_date_of_birth varchar2(10);
531: p_town_of_birth per_all_people_f.town_of_birth%type;
532: p_cntry_of_birth per_all_people_f.country_of_birth%type;
533: p_date_of_death varchar2(10);
534: p_orig_dt_of_hire varchar2(10);
535: p_eff_start_date varchar2(10);

Line 532: p_cntry_of_birth per_all_people_f.country_of_birth%type;

528: p_npw_number per_all_people_f.npw_number%type;
529: p_person_type_id per_all_people_f.person_type_id%type;
530: p_date_of_birth varchar2(10);
531: p_town_of_birth per_all_people_f.town_of_birth%type;
532: p_cntry_of_birth per_all_people_f.country_of_birth%type;
533: p_date_of_death varchar2(10);
534: p_orig_dt_of_hire varchar2(10);
535: p_eff_start_date varchar2(10);
536: p_eff_end_date varchar2(10);

Line 537: p_sex per_all_people_f.sex%type;

533: p_date_of_death varchar2(10);
534: p_orig_dt_of_hire varchar2(10);
535: p_eff_start_date varchar2(10);
536: p_eff_end_date varchar2(10);
537: p_sex per_all_people_f.sex%type;
538: p_full_name per_all_people_f.full_name%type;
539: p_suffix per_all_people_f.suffix%type;
540: p_title per_all_people_f.title%type;
541: p_last_name per_all_people_f.last_name%type;

Line 538: p_full_name per_all_people_f.full_name%type;

534: p_orig_dt_of_hire varchar2(10);
535: p_eff_start_date varchar2(10);
536: p_eff_end_date varchar2(10);
537: p_sex per_all_people_f.sex%type;
538: p_full_name per_all_people_f.full_name%type;
539: p_suffix per_all_people_f.suffix%type;
540: p_title per_all_people_f.title%type;
541: p_last_name per_all_people_f.last_name%type;
542: p_first_name per_all_people_f.first_name%type;

Line 539: p_suffix per_all_people_f.suffix%type;

535: p_eff_start_date varchar2(10);
536: p_eff_end_date varchar2(10);
537: p_sex per_all_people_f.sex%type;
538: p_full_name per_all_people_f.full_name%type;
539: p_suffix per_all_people_f.suffix%type;
540: p_title per_all_people_f.title%type;
541: p_last_name per_all_people_f.last_name%type;
542: p_first_name per_all_people_f.first_name%type;
543: p_middle_names per_all_people_f.middle_names%type;

Line 540: p_title per_all_people_f.title%type;

536: p_eff_end_date varchar2(10);
537: p_sex per_all_people_f.sex%type;
538: p_full_name per_all_people_f.full_name%type;
539: p_suffix per_all_people_f.suffix%type;
540: p_title per_all_people_f.title%type;
541: p_last_name per_all_people_f.last_name%type;
542: p_first_name per_all_people_f.first_name%type;
543: p_middle_names per_all_people_f.middle_names%type;
544: p_nationality per_all_people_f.nationality%type;

Line 541: p_last_name per_all_people_f.last_name%type;

537: p_sex per_all_people_f.sex%type;
538: p_full_name per_all_people_f.full_name%type;
539: p_suffix per_all_people_f.suffix%type;
540: p_title per_all_people_f.title%type;
541: p_last_name per_all_people_f.last_name%type;
542: p_first_name per_all_people_f.first_name%type;
543: p_middle_names per_all_people_f.middle_names%type;
544: p_nationality per_all_people_f.nationality%type;
545: p_national_identifier per_all_people_f.national_identifier%type;

Line 542: p_first_name per_all_people_f.first_name%type;

538: p_full_name per_all_people_f.full_name%type;
539: p_suffix per_all_people_f.suffix%type;
540: p_title per_all_people_f.title%type;
541: p_last_name per_all_people_f.last_name%type;
542: p_first_name per_all_people_f.first_name%type;
543: p_middle_names per_all_people_f.middle_names%type;
544: p_nationality per_all_people_f.nationality%type;
545: p_national_identifier per_all_people_f.national_identifier%type;
546: p_email_address per_all_people_f.email_address%type;

Line 543: p_middle_names per_all_people_f.middle_names%type;

539: p_suffix per_all_people_f.suffix%type;
540: p_title per_all_people_f.title%type;
541: p_last_name per_all_people_f.last_name%type;
542: p_first_name per_all_people_f.first_name%type;
543: p_middle_names per_all_people_f.middle_names%type;
544: p_nationality per_all_people_f.nationality%type;
545: p_national_identifier per_all_people_f.national_identifier%type;
546: p_email_address per_all_people_f.email_address%type;
547: p_national_id_label varchar2(200);

Line 544: p_nationality per_all_people_f.nationality%type;

540: p_title per_all_people_f.title%type;
541: p_last_name per_all_people_f.last_name%type;
542: p_first_name per_all_people_f.first_name%type;
543: p_middle_names per_all_people_f.middle_names%type;
544: p_nationality per_all_people_f.nationality%type;
545: p_national_identifier per_all_people_f.national_identifier%type;
546: p_email_address per_all_people_f.email_address%type;
547: p_national_id_label varchar2(200);
548:

Line 545: p_national_identifier per_all_people_f.national_identifier%type;

541: p_last_name per_all_people_f.last_name%type;
542: p_first_name per_all_people_f.first_name%type;
543: p_middle_names per_all_people_f.middle_names%type;
544: p_nationality per_all_people_f.nationality%type;
545: p_national_identifier per_all_people_f.national_identifier%type;
546: p_email_address per_all_people_f.email_address%type;
547: p_national_id_label varchar2(200);
548:
549:

Line 546: p_email_address per_all_people_f.email_address%type;

542: p_first_name per_all_people_f.first_name%type;
543: p_middle_names per_all_people_f.middle_names%type;
544: p_nationality per_all_people_f.nationality%type;
545: p_national_identifier per_all_people_f.national_identifier%type;
546: p_email_address per_all_people_f.email_address%type;
547: p_national_id_label varchar2(200);
548:
549:
550: TYPE ADDRESS IS RECORD

Line 617: FROM PER_ALL_PEOPLE_F ppf

613: hr_organization_information where organization_id = ppf.business_group_id
614: and org_information_context = 'Business Group Information')
615: and language_code = USERENV('LANG') )NATIONAL_IDENTIFIER_LABEL
616:
617: FROM PER_ALL_PEOPLE_F ppf
618: order by ppf.person_id,ppf.effective_start_date;
619:
620: Cursor Csr_Address_Data(P_Person_Id Number,P_Eff_St_Dt Date,P_Eff_End_Dt Date) Is
621: Select

Line 649: AND PPN.PARENT_TABLE (+) = 'PER_ALL_PEOPLE_F'

645: PHONE_TYPE,
646: PHONE_NUMBER
647: FROM per_phones ppn
648: where ppn.PARENT_ID (+) = P_PERSON_ID
649: AND PPN.PARENT_TABLE (+) = 'PER_ALL_PEOPLE_F'
650: AND DATE_FROM between P_Eff_St_Dt and P_Eff_End_Dt;
651:
652:
653: begin