DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PVT dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 7379: hr_all_organization_units_tl organ

7375:
7376: CURSOR get_organization_name(c_organization_id number)is
7377: SELECT organ.name
7378: FROM
7379: hr_all_organization_units_tl organ
7380: WHERE
7381: organ.organization_id = c_organization_id AND
7382: organ.LANGUAGE = USERENV('LANG');
7383:

Line 7392: l_source_proj_organization hr_all_organization_units_tl.name%type; /* Bug 3115273 pa_project_lists_v.carrying_out_organization_name%TYPE; */

7388: l_source_proj_id NUMBER;
7389: l_source_proj_name pa_projects_all.name%TYPE;
7390: l_source_proj_number pa_projects_all.segment1%TYPE;
7391: l_source_proj_mgr_name per_all_people_f.full_name%type; /* Bug 3115273 pa_project_lists_v.person_name%TYPE; */
7392: l_source_proj_organization hr_all_organization_units_tl.name%type; /* Bug 3115273 pa_project_lists_v.carrying_out_organization_name%TYPE; */
7393: l_source_proj_customer pa_customers_v.customer_name%type; /* Bug 3115273 pa_project_lists_v.customer_name%TYPE; */
7394: l_conflict_proj_id NUMBER;
7395: l_conflict_proj_mgr_id NUMBER;
7396: -- 3051479: Increased the size of the following two variables.