344: FUNCTION check_task_fund_allowed
345: ( p_project_id IN NUMBER
346: ) RETURN VARCHAR2
347: IS
348: l_ALLOWABLE_FUNDING_LEVEL_CODE pa_project_types_all.ALLOWABLE_FUNDING_LEVEL_CODE%type;
349:
350: BEGIN
351: Select ALLOWABLE_FUNDING_LEVEL_CODE
352: Into l_ALLOWABLE_FUNDING_LEVEL_CODE
349:
350: BEGIN
351: Select ALLOWABLE_FUNDING_LEVEL_CODE
352: Into l_ALLOWABLE_FUNDING_LEVEL_CODE
353: From pa_project_types_all pt, pa_projects_all p
354: Where p.project_id=p_project_id
355: And p.project_type=pt.project_type
356: AND p.org_id = pt.org_id; /*Bug5374298 Removed NVL join on org_id*/
357:
727: FUNCTION check_project_type
728: (p_project_id IN NUMBER
729: ) RETURN VARCHAR2
730: IS
731: l_class_code pa_project_types_all.project_type_class_code%type;
732: BEGIN
733:
734: Select pt.project_type_class_code
735: Into l_class_code
732: BEGIN
733:
734: Select pt.project_type_class_code
735: Into l_class_code
736: From pa_projects_all p, pa_project_types_all pt
737: where p.project_type = pt.project_type
738: AND p.org_id = pt.org_id /*Bug5374298 Removed NVL join on org_id*/
739: and p.project_id = p_project_id;
740: