APPS.GMS_RES_MAP dependencies on HR_ALL_ORGANIZATION_UNITS

Line 151: l_organization_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

147: l_expenditure_category varchar2(100);
148: l_revenue_category varchar2(100);
149: --l_organization_name varchar2(100);
150: --The width of the variable is changed for UTF8 changes for HRMS schema. Refer bug 2302839.
151: l_organization_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
152: l_person_name varchar2(100);
153: l_job_title varchar2(100);
154: -- The length of l_vendor_name has been changed for utf8 changes for AP schema. Refer bug 2614745.
155: --l_vendor_name varchar2(100);

Line 364: from hr_all_organization_units -- Bug 4732065

360: BEGIN
361:
362: Select name
363: into l_organization_name
364: from hr_all_organization_units -- Bug 4732065
365: where organization_id = x_expenditure_org_id;
366: EXCEPTION
367: WHEN NO_DATA_FOUND THEN
368: NULL;

Line 640: from hr_all_organization_units -- Bug 4732065

636: If l_organization_name is null then
637:
638: Select name
639: into l_organization_name
640: from hr_all_organization_units -- Bug 4732065
641: where organization_id = x_expenditure_org_id;
642:
643: End If;
644:

Line 1165: l_organization_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

1161: l_expenditure_category varchar2(100);
1162: l_revenue_category varchar2(100);
1163: --l_organization_name varchar2(100);
1164: -- The width of the variable is changed for UTF8 changes for HRMSschema. Refer bug 2302839.
1165: l_organization_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
1166:
1167:
1168: l_person_name varchar2(100);
1169: l_job_title varchar2(100);