APPS.PA_FUNDING_CORE dependencies on PA_PROJECT_TYPES

Line 151: From Pa_lookups lk, Pa_projects_all P , pa_project_types pt, pa_project_customers c

147: IS
148: /*
149: Cursor c1 is
150: Select 1
151: From Pa_lookups lk, Pa_projects_all P , pa_project_types pt, pa_project_customers c
152: where (decode(p.template_flag, 'Y', 'Y', pa_security.allow_query(p.project_id)) = 'Y'
153: and decode(p.template_flag, 'Y', 'Y', pa_security.allow_update(p.project_id)) = 'Y' )
154: and pt.project_type = p.project_type and p.project_id = c.project_id
155: and pa_project_stus_utils.is_project_status_closed(p.project_status_code) = 'N'

Line 204: FROM pa_project_types

200: WHERE project_id = p_project_id;
201:
202: SELECT project_type
203: INTO l_proj_type1
204: FROM pa_project_types
205: WHERE project_type = l_proj_type
206: AND nvl(cc_prvdr_flag,'N') ='N';
207: END IF;
208:

Line 348: l_ALLOWABLE_FUNDING_LEVEL_CODE pa_project_types_all.ALLOWABLE_FUNDING_LEVEL_CODE%type;

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

Line 353: From pa_project_types_all pt, pa_projects_all p

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:

Line 731: l_class_code pa_project_types_all.project_type_class_code%type;

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

Line 736: From pa_projects_all p, pa_project_types_all pt

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: