DBA Data[Home] [Help]

APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_RESOURCE_LIST_USES_V

Line 883: FROM pa_resource_list_uses_v

879: ORDER BY pfa.segment1, pfa.action_flag ;
880:
881: CURSOR Get_all_Budget_Types_cur(l_project_id NUMBER) IS
882: SELECT DISTINCT use_code Budget_Type_Code
883: FROM pa_resource_list_uses_v
884: WHERE project_id = l_project_id
885: AND budget_type_yn = 'Y'
886: AND use_code = NVL(Tmp_Bud_Type_Code,use_code);
887:

Line 2122: pa_resource_list_uses_v

2118:
2119: CURSOR Get_all_Budget_Types_cur(x_project_id NUMBER) IS
2120: SELECT DISTINCT use_code Budget_Type_Code
2121: FROM
2122: pa_resource_list_uses_v
2123: WHERE project_id = x_project_id
2124: AND budget_type_yn = 'Y';
2125:
2126: projrec selprjs%ROWTYPE;