APPS.PA_MCB_INVOICE_PKG dependencies on PA_SUMMARY_PROJECT_FUNDINGS

Line 747: FROM pa_summary_project_fundings

743:
744: /* this pre-existing code was commented for bug 2916606*/
745: /* SELECT FUNDING_CURRENCY_CODE
746: INTO tmp_funding_currency_code
747: FROM pa_summary_project_fundings
748: WHERE agreement_id = p_agreement_id
749: AND NVL(task_id,0) = NVL(p_task_id,0)
750: AND project_id = p_project_id
751: AND rownum=1

Line 761: from pa_summary_project_fundings

757: select funding_currency_code
758: into tmp_funding_currency_code
759: from (
760: select funding_currency_code
761: from pa_summary_project_fundings
762: where project_id = p_project_id
763: and agreement_id = p_agreement_id
764: and nvl(task_id, 0) = nvl(p_task_id, 0)
765: group by funding_currency_code

Line 778: FROM pa_summary_project_fundings

774:
775: /* this pre-existing code was commented for bug 2916606*/
776: /*SELECT FUNDING_CURRENCY_CODE
777: INTO tmp_funding_currency_code
778: FROM pa_summary_project_fundings
779: WHERE agreement_id = p_agreement_id
780: AND project_id = p_project_id
781: AND rownum=1
782: GROUP BY funding_currency_code

Line 791: from pa_summary_project_fundings

787: select funding_currency_code
788: into tmp_funding_currency_code
789: from(
790: select funding_currency_code
791: from pa_summary_project_fundings
792: where project_id = p_project_id
793: and agreement_id = p_agreement_id
794: group by funding_currency_code
795: having sum(total_baselined_amount) <> 0

Line 1826: FROM pa_summary_project_fundings

1822: ELSIF l_invproc_currency_type ='FUNDING_CURRENCY' THEN
1823:
1824: SELECT funding_currency_code
1825: INTO l_funding_currency_code
1826: FROM pa_summary_project_fundings
1827: WHERE project_id = p_project_id
1828: AND rownum=1
1829: AND NVL(total_baselined_amount,0) > 0;
1830: