APPS.PA_FUNDING_CORE dependencies on PA_PROJECTS

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 199: FROM pa_projects

195: IF (l_count >0) THEN
196:
197: SELECT project_type
198: INTO l_proj_type
199: FROM pa_projects
200: WHERE project_id = p_project_id;
201:
202: SELECT project_type
203: INTO l_proj_type1

Line 321: l_template_flag pa_projects_all.template_flag%type;

317: FUNCTION CHECK_PROJECT_TEMPLATE
318: (p_project_id IN NUMBER
319: ) RETURN VARCHAR2
320: IS
321: l_template_flag pa_projects_all.template_flag%type;
322: BEGIN
323: Select nvl(template_flag,'N')
324: into l_template_flag
325: From pa_projects_all

Line 325: From pa_projects_all

321: l_template_flag pa_projects_all.template_flag%type;
322: BEGIN
323: Select nvl(template_flag,'N')
324: into l_template_flag
325: From pa_projects_all
326: Where project_id = p_project_id;
327: RETURN l_template_flag;
328: EXCEPTION
329: When Others THEN RETURN 'N';

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 588: FROM PA_PROJECTS_ALL P, PA_AGREEMENTS_ALL A

584: BEGIN
585: --dbms_output.put_line('Inside: PA_FUNDING_CORE.CHECK_PROJ_AGR_FUND_OK');
586: SELECT 'Y'
587: INTO Is_agr_fund_ok
588: FROM PA_PROJECTS_ALL P, PA_AGREEMENTS_ALL A
589: WHERE P.PROJECT_ID = p_project_id
590: AND A.AGREEMENT_ID = p_agreement_id
591: AND (P.multi_currency_billing_flag = 'Y'
592: OR (p.multi_currency_billing_flag = 'N'

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:

Line 2165: FROM PA_Projects

2161: --dbms_output.put_line('Inside: pa_funding_core.create_funding_CO');
2162:
2163: Select Invproc_Currency_Type, Project_Currency_Code, ProjFunc_Currency_Code
2164: INTO l_Invproc_Currency_Type, l_Project_Currency_Code, l_ProjFunc_Currency_Code
2165: FROM PA_Projects
2166: Where Project_ID = P_Project_ID;
2167:
2168: IF l_Invproc_Currency_Type = 'PROJECT_CURRENCY' THEN
2169: l_Invproc_Currency_Code := l_Project_Currency_Code;