APPS.GMS_CLIENT_EXTN_BUDGET_WF dependencies on PA_PROJECT_TYPES

Line 239: FROM pa_project_types

235: --
236: CURSOR l_project_type_class( p_project_type VARCHAR2)
237: IS
238: SELECT project_type_class_code
239: FROM pa_project_types
240: WHERE project_type = p_project_type;
241: --
242: CURSOR l_starter_user_name_csr( p_starter_user_id NUMBER )
243: IS

Line 330: l_project_type_class_code pa_project_types.project_type_class_code%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;
334: l_budget_change_reason_code gms_budget_versions.change_reason_code%TYPE;

Line 977: FROM pa_project_types

973: --
974: CURSOR l_project_type_class( p_project_type VARCHAR2)
975: IS
976: SELECT project_type_class_code
977: FROM pa_project_types
978: WHERE project_type = p_project_type;
979: --
980: CURSOR l_starter_user_name_csr( p_starter_user_id NUMBER )
981: IS

Line 1068: l_project_type_class_code pa_project_types.project_type_class_code%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;
1072: l_budget_change_reason_code gms_budget_versions.change_reason_code%TYPE;