DBA Data[Home] [Help]

APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_RESOURCE_LIST_USES_V

Line 913: FROM pa_resource_list_uses_v

909: ORDER BY pfa.segment1, pfa.action_flag ;
910:
911: CURSOR Get_all_Budget_Types_cur(l_project_id NUMBER) IS
912: SELECT DISTINCT use_code Budget_Type_Code
913: FROM pa_resource_list_uses_v
914: WHERE project_id = l_project_id
915: AND budget_type_yn = 'Y'
916: AND use_code = NVL(Tmp_Bud_Type_Code,use_code);
917:

Line 2171: pa_resource_list_uses_v

2167:
2168: CURSOR Get_all_Budget_Types_cur(x_project_id NUMBER) IS
2169: SELECT DISTINCT use_code Budget_Type_Code
2170: FROM
2171: pa_resource_list_uses_v
2172: WHERE project_id = x_project_id
2173: AND budget_type_yn = 'Y';
2174:
2175: projrec selprjs%ROWTYPE;