APPS.HR_HRHD_INITIAL_LOAD dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 427: p_bg_name hr_all_organization_units_tl.name%type;

423:
424: p_bg_id hr_all_organization_units.business_group_id%type;
425: p_org_id hr_all_organization_units.organization_id%type;
426: p_lang_code varchar2(10);
427: p_bg_name hr_all_organization_units_tl.name%type;
428: p_eff_status varchar2(10);
429: p_loc_id hr_all_organization_units.location_id%type;
430: p_eff_date varchar2(10);
431: p_person_id per_org_manager_v.person_id%type;

Line 474: from hr_all_organization_units org,hr_all_organization_units_tl TL

470: and nvl(org.date_to,to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hrorg1.org_information3)
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'

Line 498: from hr_all_organization_units org,hr_all_organization_units_tl TL

494: and nvl(org.date_to,to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(hrorg1.org_information3)
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'