APPS.HR_HRHD_INITIAL_LOAD dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 271: p_bg_name hr_all_organization_units_tl.name%type;

267:
268: p_bg_id hr_all_organization_units.business_group_id%type;
269: p_org_id hr_all_organization_units.organization_id%type;
270: p_lang_code varchar2(10);
271: p_bg_name hr_all_organization_units_tl.name%type;
272: p_eff_status varchar2(10);
273: p_loc_id hr_all_organization_units.location_id%type;
274: p_eff_date varchar2(10);
275: p_person_id per_org_manager_v.person_id%type;

Line 307: from hr_all_organization_units org,hr_all_organization_units_tl TL

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

Line 331: from hr_all_organization_units org,hr_all_organization_units_tl TL

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