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 465: (select employee_number from per_all_people_f ppf,hr_organization_information hrorg1

461: TL.LANGUAGE,
462: TL.NAME,
463: ORG.LOCATION_ID,
464: /*Fix for 7576511 - to fetch employee number*/
465: (select employee_number from per_all_people_f ppf,hr_organization_information hrorg1
466: where ppf.person_id = hrorg1.ORG_INFORMATION2
467: and ppf.business_group_id = org.business_group_id
468: and hrorg1.org_information_context = 'Organization Name Alias'
469: and hrorg1.organization_id = org.organization_id

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

485: TL.LANGUAGE,
486: TL.NAME,
487: ORG.LOCATION_ID,
488: /*Fix for 7576511 - to fetch employee number*/
489: (select employee_number from per_all_people_f ppf,hr_organization_information hrorg1
490: where ppf.person_id = hrorg1.ORG_INFORMATION2
491: and ppf.business_group_id = org.business_group_id
492: and hrorg1.org_information_context = 'Organization Name Alias'
493: and hrorg1.organization_id = org.organization_id

Line 624: p_person_id per_all_people_f.person_id%type;

620: ,retcode OUT NOCOPY VARCHAR2,p_number_of_files in Number)
621: IS
622:
623:
624: p_person_id per_all_people_f.person_id%type;
625: p_assignment_id per_all_assignments_f.assignment_id%type;
626: p_assignment_number per_all_assignments_f.assignment_number%type;
627: p_effective_start_date varchar2(10);
628: p_effective_end_date varchar2(10);

Line 834: p_person_id per_all_people_f.person_id%type;

830: PROCEDURE HR_PERSON_INITIAL_LOAD(errbuf OUT NOCOPY VARCHAR2
831: ,retcode OUT NOCOPY VARCHAR2,p_number_of_files in Number)
832: IS
833:
834: p_person_id per_all_people_f.person_id%type;
835: p_business_group_id per_all_people_f.business_group_id%type;
836: p_legislation_code hr_organization_information.org_information9%type;
837: p_employee_number per_all_people_f.employee_number%type;
838: p_applicant_number per_all_people_f.applicant_number%type;

Line 835: p_business_group_id per_all_people_f.business_group_id%type;

831: ,retcode OUT NOCOPY VARCHAR2,p_number_of_files in Number)
832: IS
833:
834: p_person_id per_all_people_f.person_id%type;
835: p_business_group_id per_all_people_f.business_group_id%type;
836: p_legislation_code hr_organization_information.org_information9%type;
837: p_employee_number per_all_people_f.employee_number%type;
838: p_applicant_number per_all_people_f.applicant_number%type;
839: p_npw_number per_all_people_f.npw_number%type;

Line 837: p_employee_number per_all_people_f.employee_number%type;

833:
834: p_person_id per_all_people_f.person_id%type;
835: p_business_group_id per_all_people_f.business_group_id%type;
836: p_legislation_code hr_organization_information.org_information9%type;
837: p_employee_number per_all_people_f.employee_number%type;
838: p_applicant_number per_all_people_f.applicant_number%type;
839: p_npw_number per_all_people_f.npw_number%type;
840: p_person_type_id per_all_people_f.person_type_id%type;
841: p_date_of_birth varchar2(10);

Line 838: p_applicant_number per_all_people_f.applicant_number%type;

834: p_person_id per_all_people_f.person_id%type;
835: p_business_group_id per_all_people_f.business_group_id%type;
836: p_legislation_code hr_organization_information.org_information9%type;
837: p_employee_number per_all_people_f.employee_number%type;
838: p_applicant_number per_all_people_f.applicant_number%type;
839: p_npw_number per_all_people_f.npw_number%type;
840: p_person_type_id per_all_people_f.person_type_id%type;
841: p_date_of_birth varchar2(10);
842: p_town_of_birth per_all_people_f.town_of_birth%type;

Line 839: p_npw_number per_all_people_f.npw_number%type;

835: p_business_group_id per_all_people_f.business_group_id%type;
836: p_legislation_code hr_organization_information.org_information9%type;
837: p_employee_number per_all_people_f.employee_number%type;
838: p_applicant_number per_all_people_f.applicant_number%type;
839: p_npw_number per_all_people_f.npw_number%type;
840: p_person_type_id per_all_people_f.person_type_id%type;
841: p_date_of_birth varchar2(10);
842: p_town_of_birth per_all_people_f.town_of_birth%type;
843: p_cntry_of_birth per_all_people_f.country_of_birth%type;

Line 840: p_person_type_id per_all_people_f.person_type_id%type;

836: p_legislation_code hr_organization_information.org_information9%type;
837: p_employee_number per_all_people_f.employee_number%type;
838: p_applicant_number per_all_people_f.applicant_number%type;
839: p_npw_number per_all_people_f.npw_number%type;
840: p_person_type_id per_all_people_f.person_type_id%type;
841: p_date_of_birth varchar2(10);
842: p_town_of_birth per_all_people_f.town_of_birth%type;
843: p_cntry_of_birth per_all_people_f.country_of_birth%type;
844: p_date_of_death varchar2(10);

Line 842: p_town_of_birth per_all_people_f.town_of_birth%type;

838: p_applicant_number per_all_people_f.applicant_number%type;
839: p_npw_number per_all_people_f.npw_number%type;
840: p_person_type_id per_all_people_f.person_type_id%type;
841: p_date_of_birth varchar2(10);
842: p_town_of_birth per_all_people_f.town_of_birth%type;
843: p_cntry_of_birth per_all_people_f.country_of_birth%type;
844: p_date_of_death varchar2(10);
845: p_orig_dt_of_hire varchar2(10);
846: p_eff_start_date varchar2(10);

Line 843: p_cntry_of_birth per_all_people_f.country_of_birth%type;

839: p_npw_number per_all_people_f.npw_number%type;
840: p_person_type_id per_all_people_f.person_type_id%type;
841: p_date_of_birth varchar2(10);
842: p_town_of_birth per_all_people_f.town_of_birth%type;
843: p_cntry_of_birth per_all_people_f.country_of_birth%type;
844: p_date_of_death varchar2(10);
845: p_orig_dt_of_hire varchar2(10);
846: p_eff_start_date varchar2(10);
847: p_eff_end_date varchar2(10);

Line 848: p_sex per_all_people_f.sex%type;

844: p_date_of_death varchar2(10);
845: p_orig_dt_of_hire varchar2(10);
846: p_eff_start_date varchar2(10);
847: p_eff_end_date varchar2(10);
848: p_sex per_all_people_f.sex%type;
849: p_full_name per_all_people_f.full_name%type;
850: p_suffix per_all_people_f.suffix%type;
851: p_title per_all_people_f.title%type;
852: p_last_name per_all_people_f.last_name%type;

Line 849: p_full_name per_all_people_f.full_name%type;

845: p_orig_dt_of_hire varchar2(10);
846: p_eff_start_date varchar2(10);
847: p_eff_end_date varchar2(10);
848: p_sex per_all_people_f.sex%type;
849: p_full_name per_all_people_f.full_name%type;
850: p_suffix per_all_people_f.suffix%type;
851: p_title per_all_people_f.title%type;
852: p_last_name per_all_people_f.last_name%type;
853: p_first_name per_all_people_f.first_name%type;

Line 850: p_suffix per_all_people_f.suffix%type;

846: p_eff_start_date varchar2(10);
847: p_eff_end_date varchar2(10);
848: p_sex per_all_people_f.sex%type;
849: p_full_name per_all_people_f.full_name%type;
850: p_suffix per_all_people_f.suffix%type;
851: p_title per_all_people_f.title%type;
852: p_last_name per_all_people_f.last_name%type;
853: p_first_name per_all_people_f.first_name%type;
854: p_middle_names per_all_people_f.middle_names%type;

Line 851: p_title per_all_people_f.title%type;

847: p_eff_end_date varchar2(10);
848: p_sex per_all_people_f.sex%type;
849: p_full_name per_all_people_f.full_name%type;
850: p_suffix per_all_people_f.suffix%type;
851: p_title per_all_people_f.title%type;
852: p_last_name per_all_people_f.last_name%type;
853: p_first_name per_all_people_f.first_name%type;
854: p_middle_names per_all_people_f.middle_names%type;
855: p_nationality per_all_people_f.nationality%type;

Line 852: p_last_name per_all_people_f.last_name%type;

848: p_sex per_all_people_f.sex%type;
849: p_full_name per_all_people_f.full_name%type;
850: p_suffix per_all_people_f.suffix%type;
851: p_title per_all_people_f.title%type;
852: p_last_name per_all_people_f.last_name%type;
853: p_first_name per_all_people_f.first_name%type;
854: p_middle_names per_all_people_f.middle_names%type;
855: p_nationality per_all_people_f.nationality%type;
856: p_national_identifier per_all_people_f.national_identifier%type;

Line 853: p_first_name per_all_people_f.first_name%type;

849: p_full_name per_all_people_f.full_name%type;
850: p_suffix per_all_people_f.suffix%type;
851: p_title per_all_people_f.title%type;
852: p_last_name per_all_people_f.last_name%type;
853: p_first_name per_all_people_f.first_name%type;
854: p_middle_names per_all_people_f.middle_names%type;
855: p_nationality per_all_people_f.nationality%type;
856: p_national_identifier per_all_people_f.national_identifier%type;
857: p_email_address per_all_people_f.email_address%type;

Line 854: p_middle_names per_all_people_f.middle_names%type;

850: p_suffix per_all_people_f.suffix%type;
851: p_title per_all_people_f.title%type;
852: p_last_name per_all_people_f.last_name%type;
853: p_first_name per_all_people_f.first_name%type;
854: p_middle_names per_all_people_f.middle_names%type;
855: p_nationality per_all_people_f.nationality%type;
856: p_national_identifier per_all_people_f.national_identifier%type;
857: p_email_address per_all_people_f.email_address%type;
858: p_national_id_label varchar2(200);

Line 855: p_nationality per_all_people_f.nationality%type;

851: p_title per_all_people_f.title%type;
852: p_last_name per_all_people_f.last_name%type;
853: p_first_name per_all_people_f.first_name%type;
854: p_middle_names per_all_people_f.middle_names%type;
855: p_nationality per_all_people_f.nationality%type;
856: p_national_identifier per_all_people_f.national_identifier%type;
857: p_email_address per_all_people_f.email_address%type;
858: p_national_id_label varchar2(200);
859:

Line 856: p_national_identifier per_all_people_f.national_identifier%type;

852: p_last_name per_all_people_f.last_name%type;
853: p_first_name per_all_people_f.first_name%type;
854: p_middle_names per_all_people_f.middle_names%type;
855: p_nationality per_all_people_f.nationality%type;
856: p_national_identifier per_all_people_f.national_identifier%type;
857: p_email_address per_all_people_f.email_address%type;
858: p_national_id_label varchar2(200);
859:
860: l_record_counter Number :=0;

Line 857: p_email_address per_all_people_f.email_address%type;

853: p_first_name per_all_people_f.first_name%type;
854: p_middle_names per_all_people_f.middle_names%type;
855: p_nationality per_all_people_f.nationality%type;
856: p_national_identifier per_all_people_f.national_identifier%type;
857: p_email_address per_all_people_f.email_address%type;
858: p_national_id_label varchar2(200);
859:
860: l_record_counter Number :=0;
861: l_file_counter Number :=0;

Line 938: FROM PER_ALL_PEOPLE_F ppf

934: hr_organization_information where organization_id = ppf.business_group_id
935: and org_information_context = 'Business Group Information')
936: and language_code = USERENV('LANG') )NATIONAL_IDENTIFIER_LABEL
937:
938: FROM PER_ALL_PEOPLE_F ppf
939: order by ppf.person_id,ppf.effective_start_date;
940:
941: Cursor Csr_Address_Data(P_Person_Id Number,P_Eff_St_Dt Date,P_Eff_End_Dt Date) Is
942: Select

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

968: PHONE_TYPE,
969: PHONE_NUMBER
970: FROM per_phones ppn
971: where ppn.PARENT_ID (+) = P_PERSON_ID
972: AND PPN.PARENT_TABLE (+) = 'PER_ALL_PEOPLE_F'
973: AND DATE_FROM between P_Eff_St_Dt and P_Eff_End_Dt;
974:
975:
976: begin