APPS.PA_AGREEMENT_CORE dependencies on PA_PROJECT_FUNDINGS

Line 356: FROM PA_PROJECT_FUNDINGS F

352: RETURN VARCHAR2
353: IS
354: CURSOR c IS
355: SELECT 1
356: FROM PA_PROJECT_FUNDINGS F
357: WHERE F.pm_funding_reference = p_funding_reference
358: AND F.agreement_id = p_agreement_id ;
359: l_row c%ROWTYPE;
360: BEGIN

Line 394: FROM PA_PROJECT_FUNDINGS F

390: RETURN VARCHAR2
391: IS
392: CURSOR c IS
393: SELECT 1
394: FROM PA_PROJECT_FUNDINGS F
395: WHERE F.project_funding_id = p_funding_id
396: AND F.agreement_id = p_agreement_id ;
397: l_row c%ROWTYPE;
398: BEGIN

Line 471: FROM PA_PROJECT_FUNDINGS f

467:
468: CURSOR c1
469: IS
470: SELECT f.project_funding_id
471: FROM PA_PROJECT_FUNDINGS f
472: WHERE f.project_funding_id = p_funding_id;
473:
474: CURSOR c2
475: IS

Line 477: FROM PA_PROJECT_FUNDINGS f

473:
474: CURSOR c2
475: IS
476: SELECT f.project_funding_id
477: FROM PA_PROJECT_FUNDINGS f
478: WHERE f.pm_funding_reference = p_funding_reference;
479:
480: l_fund_rec1 c1%ROWTYPE;
481: l_fund_rec2 c2%ROWTYPE;

Line 528: FROM PA_PROJECT_FUNDINGS f

524:
525: CURSOR c1
526: IS
527: SELECT f.agreement_id
528: FROM PA_PROJECT_FUNDINGS f
529: WHERE f.project_funding_id = p_funding_id;
530:
531: CURSOR c2
532: IS

Line 534: FROM PA_PROJECT_FUNDINGS f

530:
531: CURSOR c2
532: IS
533: SELECT f.agreement_id
534: FROM PA_PROJECT_FUNDINGS f
535: WHERE f.pm_funding_reference = p_funding_reference;
536:
537: l_fund_rec1 c1%ROWTYPE;
538: l_fund_rec2 c2%ROWTYPE;

Line 600: FROM PA_PROJECT_FUNDINGS f

596:
597: CURSOR c1
598: IS
599: SELECT f.project_id
600: FROM PA_PROJECT_FUNDINGS f
601: WHERE f.project_funding_id = p_funding_id;
602:
603: CURSOR c2
604: IS

Line 606: FROM PA_PROJECT_FUNDINGS f

602:
603: CURSOR c2
604: IS
605: SELECT f.project_id
606: FROM PA_PROJECT_FUNDINGS f
607: WHERE f.pm_funding_reference = p_funding_reference;
608:
609: l_fund_rec1 c1%ROWTYPE;
610: l_fund_rec2 c2%ROWTYPE;

Line 661: FROM PA_PROJECT_FUNDINGS f

657:
658: CURSOR c1
659: IS
660: SELECT f.task_id
661: FROM PA_PROJECT_FUNDINGS f
662: WHERE f.project_funding_id = p_funding_id;
663:
664: CURSOR c2
665: IS

Line 667: FROM PA_PROJECT_FUNDINGS f

663:
664: CURSOR c2
665: IS
666: SELECT f.task_id
667: FROM PA_PROJECT_FUNDINGS f
668: WHERE f.pm_funding_reference = p_funding_reference;
669:
670: l_fund_rec1 c1%ROWTYPE;
671: l_fund_rec2 c2%ROWTYPE;

Line 722: FROM PA_PROJECT_FUNDINGS f

718: IS
719: SELECT A.customer_id
720: FROM PA_AGREEMENTS_ALL A
721: WHERE A.agreement_id = (SELECT f.agreement_id
722: FROM PA_PROJECT_FUNDINGS f
723: WHERE f.project_funding_id = p_funding_id);
724:
725: CURSOR c2
726: IS

Line 730: FROM PA_PROJECT_FUNDINGS f

726: IS
727: SELECT A.customer_id
728: FROM PA_AGREEMENTS_ALL A
729: WHERE A.agreement_id = (SELECT f.agreement_id
730: FROM PA_PROJECT_FUNDINGS f
731: WHERE f.pm_funding_reference = p_funding_reference);
732:
733: l_fund_rec1 c1%ROWTYPE;
734: l_fund_rec2 c2%ROWTYPE;

Line 1282: FROM pa_project_fundings f1

1278: BEGIN
1279: -- dbms_output.put_line('Inside" PA_AGREEMENT_CORE.CHECK_BUDGET_TYPE');
1280: SELECT budget_type_code
1281: INTO budget_type_code
1282: FROM pa_project_fundings f1
1283: WHERE f1.project_funding_id = p_funding_id;
1284:
1285: IF budget_type_code = 'DRAFT' then
1286: RETURN 'Y';