APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_SUMMARY_PROJECT_FUNDINGS

Line 216: FROM pa_summary_project_fundings

212: BEGIN
213:
214: SELECT funding_currency_code
215: INTO x_invproc_currency_code
216: FROM pa_summary_project_fundings
217: WHERE project_id = p_project_id
218: AND rownum = 1
219: AND NVL(total_baselined_amount,0) > 0; /* Added for bug 2834362 */
220: /*

Line 475: FROM pa_summary_project_fundings

471: BEGIN
472:
473: SELECT funding_currency_code
474: INTO l_invproc_currency_code
475: FROM pa_summary_project_fundings
476: WHERE project_id = p_project_id
477: AND rownum = 1;
478:
479: EXCEPTION

Line 841: PA_SUMMARY_PROJECT_FUNDINGS spf

837: fc.currency_code in (pr.project_currency_code,
838: pr.projfunc_currency_code)
839: UNION
840: SELECT null from
841: PA_SUMMARY_PROJECT_FUNDINGS spf
842: WHERE project_id = p_project_id
843: AND spf.funding_currency_code = fc.currency_code
844: AND spf.total_baselined_amount <> 0 )
845: ORDER BY currency_code;

Line 1181: FROM pa_summary_project_fundings spf, pa_agreements a,

1177: BEGIN
1178:
1179: SELECT 'Y' INTO lv_return_flag FROM DUAL
1180: WHERE EXISTS ( SELECT spf.project_id
1181: FROM pa_summary_project_fundings spf, pa_agreements a,
1182: pa_projects_all P
1183: WHERE spf.agreement_id = a.agreement_id
1184: AND spf.project_id = p.project_id
1185: AND a.org_id <> p.org_id);

Line 1654: pa_summary_project_fundings f

1650: IS
1651: CURSOR C_fund IS
1652: SELECT 'x'
1653: FROM pa_agreements a,
1654: pa_summary_project_fundings f
1655: WHERE a.customer_id = p_proj_customer_id
1656: AND a.agreement_id = f.agreement_id
1657: AND f.project_id = p_project_id
1658: AND ( f.total_unbaselined_amount <>0