APPS.PAY_AU_DLEC dependencies on HR_ALL_ORGANIZATION_UNITS

Line 62: l_business_group_name hr_all_organization_units.name%type;

58: l_year number := 0;
59: l_fin_year_start date;
60: l_fin_year_end date;
61: l_today date;
62: l_business_group_name hr_all_organization_units.name%type;
63:
64: type l_asg_rec is record
65: (assignment_id per_all_assignments_f.assignment_id%type,
66: assignment_number per_all_assignments_f.assignment_number%type,

Line 96: from hr_all_organization_units hou,

92: -- Get the business group name.
93:
94: select hou.name
95: into l_business_group_name
96: from hr_all_organization_units hou,
97: hr_organization_information hoi
98: where hou.organization_id = hou.business_group_id
99: and hou.organization_id = hoi.organization_id
100: and hoi.org_information_context = 'Business Group Information'