APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_SUMMARY_PROJECT_FUNDINGS

Line 1646: from pa_summary_project_fundings fu,

1642: cursor c1 is
1643: select 'Y' from dual
1644: where exists (
1645: select 'x'
1646: from pa_summary_project_fundings fu,
1647: pa_budget_versions bv
1648: where fu.agreement_id = p_agreement_id
1649: and bv.project_id = fu.project_id
1650: and bv.agreement_id = p_agreement_id);

Line 1718: from pa_summary_project_fundings fu,

1714: cursor c1 is
1715: select 'Y' from dual
1716: where exists (
1717: select 'x'
1718: from pa_summary_project_fundings fu,
1719: pa_budget_versions bv
1720: where fu.agreement_id = p_agreement_id
1721: and bv.project_id = fu.project_id
1722: and bv.agreement_id = p_agreement_id);

Line 2237: Pa_Summary_Project_Fundings spf

2233: END IF;
2234:
2235: SELECT a.Agreement_Id INTO x_agreement_id FROM
2236: Pa_Agreements_All a,
2237: Pa_Summary_Project_Fundings spf
2238: WHERE
2239: a.agreement_num = p_agreement_number AND
2240: a.agreement_id = spf.agreement_id AND
2241: spf.project_id = p_project_id AND

Line 2436: pa_summary_project_fundings

2432: BEGIN
2433: SELECT SUM(NVL(total_baselined_amount,0)) INTO
2434: l_funding_amount
2435: FROM
2436: pa_summary_project_fundings
2437: WHERE
2438: project_id = p_project_id AND
2439: agreement_id = p_agreement_id;
2440: RETURN l_funding_amount;