APPS.GMS_BUDGET_PUB dependencies on PA_PROJECT_TYPES

Line 2668: FROM pa_project_types t,

2664: CURSOR l_budget_rules_csr(p_draft_version_id NUMBER)
2665: IS
2666: SELECT v.resource_list_id,
2667: t.project_type_class_code
2668: FROM pa_project_types t,
2669: pa_projects p,
2670: gms_budget_versions v
2671: WHERE v.budget_version_id = p_draft_version_id
2672: AND v.project_id = p.project_id

Line 2682: FROM pa_project_types t,

2678: IS
2679: SELECT v.resource_list_id,
2680: t.project_type_class_code,
2681: prl.group_resource_type_id
2682: FROM pa_project_types t,
2683: pa_projects p,
2684: pa_resource_lists prl,
2685: gms_budget_versions v
2686: WHERE v.budget_version_id = p_draft_version_id

Line 2767: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;

2763:
2764: l_group_resource_type_id NUMBER; -- Used for Budgetary Control Setup.
2765: l_entry_level_code VARCHAR2(30); -- Used for Budgetary Control Setup.
2766:
2767: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
2768:
2769: l_warnings_only_flag VARCHAR2(1) := 'Y';
2770: l_err_msg_count NUMBER := 0;
2771: l_old_stack VARCHAR2(630);