APPS.GMS_CLIENT_EXTN_BUDGET_WF dependencies on HR_ORGANIZATION_UNITS

Line 233: FROM hr_organization_units

229:
230: CURSOR l_organization_csr ( p_carrying_out_organization_id NUMBER )
231: IS
232: SELECT name
233: FROM hr_organization_units
234: WHERE organization_id = p_carrying_out_organization_id;
235: --
236: CURSOR l_project_type_class( p_project_type VARCHAR2)
237: IS

Line 329: l_carrying_out_org_name hr_organization_units.name%TYPE;

325: l_description pa_projects.description%TYPE;
326: l_project_type pa_projects.project_type%TYPE;
327: l_pm_project_product_code pa_projects.pm_product_code%TYPE;
328: l_carrying_out_org_id NUMBER;
329: l_carrying_out_org_name hr_organization_units.name%TYPE;
330: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
331:
332: l_pm_budget_reference gms_budget_versions.pm_budget_reference%TYPE;
333: l_budget_description gms_budget_versions.description%TYPE;

Line 971: FROM hr_organization_units

967:
968: CURSOR l_organization_csr ( p_carrying_out_organization_id NUMBER )
969: IS
970: SELECT name
971: FROM hr_organization_units
972: WHERE organization_id = p_carrying_out_organization_id;
973: --
974: CURSOR l_project_type_class( p_project_type VARCHAR2)
975: IS

Line 1067: l_carrying_out_org_name hr_organization_units.name%TYPE;

1063: l_description pa_projects.description%TYPE;
1064: l_project_type pa_projects.project_type%TYPE;
1065: l_pm_project_product_code pa_projects.pm_product_code%TYPE;
1066: l_carrying_out_org_id NUMBER;
1067: l_carrying_out_org_name hr_organization_units.name%TYPE;
1068: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
1069:
1070: l_pm_budget_reference gms_budget_versions.pm_budget_reference%TYPE;
1071: l_budget_description gms_budget_versions.description%TYPE;