DBA Data[Home] [Help]

APPS.PA_CLIENT_EXTN_BUDGET_WF dependencies on HR_ORGANIZATION_UNITS

Line 327: FROM hr_organization_units

323: --
324: CURSOR l_organization_csr ( p_carrying_out_organization_id NUMBER )
325: IS
326: SELECT name
327: FROM hr_organization_units
328: WHERE organization_id = p_carrying_out_organization_id;
329: --
330: CURSOR l_project_type_class( p_project_type VARCHAR2)
331: IS

Line 433: l_carrying_out_org_name hr_organization_units.name%TYPE;

429: l_description pa_projects.description%TYPE;
430: l_project_type pa_projects.project_type%TYPE;
431: l_pm_project_product_code pa_projects.pm_product_code%TYPE;
432: l_carrying_out_org_id NUMBER;
433: l_carrying_out_org_name hr_organization_units.name%TYPE;
434: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
435:
436: l_pm_budget_reference pa_budget_versions.pm_budget_reference%TYPE;
437: l_budget_description pa_budget_versions.description%TYPE;