427: ,c_business_group_id in number
428: ,c_effective_date in date
429: ) is
430: select htl.name
431: from hr_all_organization_units_tl htl
432: ,hr_all_organization_units hao
433: where hao.organization_id = c_organization_id
434: and hao.business_group_id = c_business_group_id
435: and htl.organization_id = hao.organization_id
10373: l_party_id per_people_f.party_id%type;
10374: l_dff_ctx fnd_descr_flex_contexts.descriptive_flex_context_code%type;
10375:
10376: -- added by dbansal
10377: l_gre_name HR_ALL_ORGANIZATION_UNITS_TL.name%type;
10378: temp varchar2(20);
10379: --
10380: -- Date variables
10381: --