APPS.GMS_BUDGET_PUB dependencies on PA_PROJECT_TYPES

Line 2667: FROM pa_project_types t,

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

Line 2681: FROM pa_project_types t,

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

Line 2766: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;

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