APPS.AS_SC_DENORM_TRG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 725: l_business_group_name hr_all_organization_units_tl.name%Type;

721: l_item_description as_sales_credits_denorm.item_description%Type;
722: l_revenue_flag aso_i_sales_credit_types_v.quota_flag%Type;
723: l_parent_project as_leads_all.parent_project%Type;
724: l_partner_cust_name hz_parties.party_name%Type;
725: l_business_group_name hr_all_organization_units_tl.name%Type;
726: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
727:
728: Begin
729: IF l_debug THEN

Line 1031: From hr_all_organization_units_tl

1027: End;
1028:
1029: Begin
1030: Select name Into l_business_group_name
1031: From hr_all_organization_units_tl
1032: Where organization_id = l_org_id
1033: and language = userenv('LANG');
1034: Exception When others then
1035: l_business_group_name := Null;