APPS.PAY_US_W2_BOX_BAL dependencies on HR_ORGANIZATION_UNITS

Line 47: lv_business_group_name hr_organization_units.name%TYPE;

43: lv_description fnd_common_lookups.description%TYPE := null;
44: ln_application_id fnd_common_lookups.application_id%TYPE := 0;
45: lv_live_dbi ff_database_items.user_name%TYPE := null;
46: lv_archive_dbi ff_database_items.user_name%TYPE := null;
47: lv_business_group_name hr_organization_units.name%TYPE;
48:
49: lv_dimension varchar2(60) := 'Person within Government Reporting Entity Year to Date';
50: ln_bal_type_id number:= 0;
51: lv_legislation varchar2(2) := 'US';

Line 93: select name from hr_organization_units

89: from ff_user_entities fue
90: where user_entity_name = cp_archive_dbi;
91:
92: CURSOR c_get_business_group(cp_business_group_id in number)is
93: select name from hr_organization_units
94: where organization_id = cp_business_group_id;
95:
96: BEGIN
97: