APPS.PA_ADVERTISEMENTS_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1234: l_project_organization HR_ALL_ORGANIZATION_UNITS.name%TYPE;

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

Line 1325: HR_ALL_ORGANIZATION_UNITS HOU

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