APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_SUMMARY_PROJECT_FUNDINGS

Line 1680: from pa_summary_project_fundings fu,

1676: cursor c1 is
1677: select 'Y' from dual
1678: where exists (
1679: select 'x'
1680: from pa_summary_project_fundings fu,
1681: pa_budget_versions bv
1682: where fu.agreement_id = p_agreement_id
1683: and bv.project_id = fu.project_id
1684: and bv.agreement_id = p_agreement_id);

Line 1752: from pa_summary_project_fundings fu,

1748: cursor c1 is
1749: select 'Y' from dual
1750: where exists (
1751: select 'x'
1752: from pa_summary_project_fundings fu,
1753: pa_budget_versions bv
1754: where fu.agreement_id = p_agreement_id
1755: and bv.project_id = fu.project_id
1756: and bv.agreement_id = p_agreement_id);

Line 2271: Pa_Summary_Project_Fundings spf

2267: END IF;
2268:
2269: SELECT a.Agreement_Id INTO x_agreement_id FROM
2270: Pa_Agreements_All a,
2271: Pa_Summary_Project_Fundings spf
2272: WHERE
2273: a.agreement_num = p_agreement_number AND
2274: a.agreement_id = spf.agreement_id AND
2275: spf.project_id = p_project_id AND

Line 2470: pa_summary_project_fundings

2466: BEGIN
2467: SELECT SUM(NVL(total_baselined_amount,0)) INTO
2468: l_funding_amount
2469: FROM
2470: pa_summary_project_fundings
2471: WHERE
2472: project_id = p_project_id AND
2473: agreement_id = p_agreement_id;
2474: RETURN l_funding_amount;