APPS.HR_HRHD_INITIAL_LOAD dependencies on HR_ORGANIZATION_INFORMATION

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 475: ,hr_organization_information hrorg

471: and nvl(fnd_date.canonical_to_date(hrorg1.org_information4),to_date('31/12/4712','DD/MM/YYYY'))
472: and fnd_date.canonical_to_date(hrorg1.org_information3) between ppf.effective_start_date and ppf.effective_end_date) MANAGER_ID
473:
474: from hr_all_organization_units org,hr_all_organization_units_tl TL
475: ,hr_organization_information hrorg
476: where tl.organization_id = org.organization_id
477: and hrorg.organization_id = org.organization_id
478: and hrorg.org_information1 = 'HR_ORG'
479: and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY')) > sysdate

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 499: ,hr_organization_information hrorg

495: and nvl(fnd_date.canonical_to_date(hrorg1.org_information4),to_date('31/12/4712','DD/MM/YYYY'))
496: and fnd_date.canonical_to_date(hrorg1.org_information3) between ppf.effective_start_date and ppf.effective_end_date) MANAGER_ID
497:
498: from hr_all_organization_units org,hr_all_organization_units_tl TL
499: ,hr_organization_information hrorg
500: where tl.organization_id = org.organization_id
501: and hrorg.organization_id = org.organization_id
502: and hrorg.org_information1 = 'HR_ORG'
503: and date_to is not null

Line 836: p_legislation_code hr_organization_information.org_information9%type;

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;
840: p_person_type_id per_all_people_f.person_type_id%type;

Line 910: hr_organization_information where organization_id = ppf.business_group_id

906: cursor csr_person_data is
907: SELECT ppf.person_id,
908: ppf.business_group_id,
909: (select org_information9 from
910: hr_organization_information where organization_id = ppf.business_group_id
911: and org_information_context = 'Business Group Information') LEGISLATION_CODE,
912: EMPLOYEE_NUMBER,
913: APPLICANT_NUMBER,
914: NPW_NUMBER,

Line 934: hr_organization_information where organization_id = ppf.business_group_id

930: NATIONALITY,
931: NATIONAL_IDENTIFIER,
932: EMAIL_ADDRESS,
933: (select message_text from fnd_new_messages where message_name = 'HR_NATIONAL_ID_NUMBER_'|| (select to_char(org_information9) from
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