APPS.PAY_US_USERRA dependencies on HR_ORGANIZATION_UNITS

Line 35: lv_business_group_name hr_organization_units.name%TYPE;

31: lv_archive_dbi ff_database_items.user_name%TYPE := null;
32: lv_year varchar2(4);
33: lv_short_year varchar2(2) := null;
34: ld_year date;
35: lv_business_group_name hr_organization_units.name%TYPE;
36:
37: lv_dimension varchar2(60) := 'Person within Government Reporting Entity Year to Date';
38: ln_bal_type_id number:= 0;
39: lv_legislation varchar2(2) := 'US';

Line 74: select name from hr_organization_units

70: from ff_user_entities fue
71: where user_entity_name = cp_archive_dbi;
72:
73: CURSOR c_get_business_group(cp_business_group_id in number)is
74: select name from hr_organization_units
75: where organization_id = cp_business_group_id;
76:
77: BEGIN
78: