DBA Data[Home] [Help]

APPS.PA_PROGRESS_PUB dependencies on PA_RESOURCE_ASSIGNMENTS

Line 10501: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE; -- Bug 3595585

10497: l_rate_based_flag VARCHAR2(1); -- Bug 3595585
10498: l_ETC_TXN_BURDENED_COST NUMBER; -- Bug 3595585
10499: l_ETC_PRJ_BURDENED_COST NUMBER; -- Bug 3595585
10500: l_ETC_PFC_BURDENED_COST NUMBER; -- Bug 3595585
10501: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE; -- Bug 3595585
10502: l_PLAN_TYPE_ID NUMBER; -- Bug 3595585
10503: l_PLAN_VERSION_ID NUMBER; -- Bug 3595585
10504: L_BASE_STRUCT_VER_ID NUMBER; -- Bug 3595585
10505: l_msg_code VARCHAR2(32);

Line 14412: FROM pa_resource_assignments ra,

14408: WHERE proj_element_id=l_proj_element_id;
14409: CURSOR get_res_assignment_name (l_resource_assignment_id NUMBER)
14410: IS
14411: SELECT rlm.ALIAS
14412: FROM pa_resource_assignments ra,
14413: pa_resource_list_members rlm
14414: WHERE ra.resource_list_member_id=rlm.resource_list_member_id
14415: AND ra.resource_assignment_id =l_resource_assignment_id;
14416: CURSOR get_budget_version_name(l_budget_version_id NUMBER)