APPS.PQP_PERASGADD_RIW dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 430: from hr_all_organization_units_tl htl

426: ,c_business_group_id in number
427: ,c_effective_date in date
428: ) is
429: select htl.name
430: from hr_all_organization_units_tl htl
431: ,hr_all_organization_units hao
432: where hao.organization_id = c_organization_id
433: and hao.business_group_id = c_business_group_id
434: and htl.organization_id = hao.organization_id

Line 9720: l_gre_name HR_ALL_ORGANIZATION_UNITS_TL.name%type;

9716: l_party_id per_people_f.party_id%type;
9717: l_dff_ctx fnd_descr_flex_contexts.descriptive_flex_context_code%type;
9718:
9719: -- added by dbansal
9720: l_gre_name HR_ALL_ORGANIZATION_UNITS_TL.name%type;
9721: temp varchar2(20);
9722: --
9723: -- Date variables
9724: --