APPS.PA_FUNDING_CORE dependencies on PA_PROJECTS_ALL

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 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: