APPS.PA_ADVERTISEMENTS_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1235: l_project_organization HR_ALL_ORGANIZATION_UNITS.name%TYPE;

1231: l_description pa_project_assignments.description%TYPE;
1232: l_additional_information pa_project_assignments.additional_information%TYPE;
1233: l_project_name pa_projects_all.name%TYPE;
1234: l_project_number pa_projects_all.segment1%TYPE;
1235: l_project_organization HR_ALL_ORGANIZATION_UNITS.name%TYPE;
1236: -- 4363092 TCA changes, replaced RA views with HZ tables
1237: --l_project_customer RA_CUSTOMERS.customer_name%TYPE;
1238: l_project_customer hz_parties.party_name%TYPE;
1239: -- 4363092 done

Line 1326: HR_ALL_ORGANIZATION_UNITS HOU

1322: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER(proj.project_id),
1323: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER_NAME,
1324: PA_PROJECTS_MAINT_UTILS.GET_PRIMARY_CUSTOMER_NAME(proj.project_id)
1325: FROM pa_projects_all proj,
1326: HR_ALL_ORGANIZATION_UNITS HOU
1327: WHERE proj.project_id = p_project_id
1328: AND proj.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID;
1329:
1330: BEGIN