DBA Data[Home] [Help]

APPS.PA_CLIENT_EXTN_PROJECT_WF dependencies on HR_ORGANIZATION_UNITS

Line 166: FROM hr_organization_units

162: --
163: CURSOR l_organization_csr ( l_carrying_out_organization_id NUMBER )
164: IS
165: SELECT name
166: FROM hr_organization_units
167: WHERE organization_id = l_carrying_out_organization_id;
168: --
169: CURSOR l_project_type_class( l_project_type VARCHAR2)
170: IS

Line 271: l_carrying_out_org_name hr_organization_units.name%TYPE;

267: l_pm_product_code varchar2(30);
268: l_carrying_out_org_id number;
269: /* Bug No:- 2487147, UTF8 change : changed l_carrying_out_org_name to %TYPE */
270: /* l_carrying_out_org_name varchar2(60); */
271: l_carrying_out_org_name hr_organization_units.name%TYPE;
272: l_project_type_class_code varchar2(30);
273:
274: l_project_status_code pa_project_statuses.project_status_code%TYPE;
275: l_wf_success_status_code pa_project_statuses.project_status_code%TYPE;