APPS.HR_HRHD_INITIAL_LOAD dependencies on HR_ORGANIZATION_INFORMATION

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

304: and nvl(fnd_date.canonical_to_date(hrorg1.org_information4),to_date('31/12/4712','DD/MM/YYYY'))
305: and fnd_date.canonical_to_date(hrorg1.org_information3) between ppf.effective_start_date and ppf.effective_end_date) MANAGER_ID
306:
307: from hr_all_organization_units org,hr_all_organization_units_tl TL
308: ,hr_organization_information hrorg
309: where tl.organization_id = org.organization_id
310: and hrorg.organization_id = org.organization_id
311: and hrorg.org_information1 = 'HR_ORG'
312: and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY')) > sysdate

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

328: and nvl(fnd_date.canonical_to_date(hrorg1.org_information4),to_date('31/12/4712','DD/MM/YYYY'))
329: and fnd_date.canonical_to_date(hrorg1.org_information3) between ppf.effective_start_date and ppf.effective_end_date) MANAGER_ID
330:
331: from hr_all_organization_units org,hr_all_organization_units_tl TL
332: ,hr_organization_information hrorg
333: where tl.organization_id = org.organization_id
334: and hrorg.organization_id = org.organization_id
335: and hrorg.org_information1 = 'HR_ORG'
336: and date_to is not null

Line 525: p_legislation_code hr_organization_information.org_information9%type;

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

Line 589: hr_organization_information where organization_id = ppf.business_group_id

585: cursor csr_person_data is
586: SELECT ppf.person_id,
587: ppf.business_group_id,
588: (select org_information9 from
589: hr_organization_information where organization_id = ppf.business_group_id
590: and org_information_context = 'Business Group Information') LEGISLATION_CODE,
591: EMPLOYEE_NUMBER,
592: APPLICANT_NUMBER,
593: NPW_NUMBER,

Line 613: hr_organization_information where organization_id = ppf.business_group_id

609: NATIONALITY,
610: NATIONAL_IDENTIFIER,
611: EMAIL_ADDRESS,
612: (select message_text from fnd_new_messages where message_name = 'HR_NATIONAL_ID_NUMBER_'|| (select to_char(org_information9) from
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