APPS.PAY_US_XDO_REPORT dependencies on HR_ORGANIZATION_UNITS

Line 147: l_business_group_name hr_organization_units.name%TYPE;

143:
144: /* This Procedure writes the header details for GTN Report*/
145: PROCEDURE WRITE_HEADER
146: IS
147: l_business_group_name hr_organization_units.name%TYPE;
148: l_payroll_name VARCHAR2(80);
149: l_print_set_payroll_name VARCHAR2(120);
150: l_consolidation_set_name VARCHAR2(80);
151: l_gre_name VARCHAR2(80);

Line 207: FROM hr_organization_units

203:
204: IF l_gre_id IS NOT NULL THEN
205: SELECT substr(name,1,80)
206: INTO l_gre_name
207: FROM hr_organization_units
208: WHERE organization_id = l_gre_id;
209: END IF;
210:
211: --hr_utility.trace (' l_gre_name : '|| l_gre_name );