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 834: PA_SUMMARY_PROJECT_FUNDINGS spf

830: fc.currency_code in (pr.project_currency_code,
831: pr.projfunc_currency_code)
832: UNION
833: SELECT null from
834: PA_SUMMARY_PROJECT_FUNDINGS spf
835: WHERE project_id = p_project_id
836: AND spf.funding_currency_code = fc.currency_code
837: AND spf.total_baselined_amount <> 0 )
838: ORDER BY currency_code;

Line 1174: FROM pa_summary_project_fundings spf, pa_agreements a,

1170: BEGIN
1171:
1172: SELECT 'Y' INTO lv_return_flag FROM DUAL
1173: WHERE EXISTS ( SELECT spf.project_id
1174: FROM pa_summary_project_fundings spf, pa_agreements a,
1175: pa_projects_all P
1176: WHERE spf.agreement_id = a.agreement_id
1177: AND spf.project_id = p.project_id
1178: AND a.org_id <> p.org_id);

Line 1647: pa_summary_project_fundings f

1643: IS
1644: CURSOR C_fund IS
1645: SELECT 'x'
1646: FROM pa_agreements a,
1647: pa_summary_project_fundings f
1648: WHERE a.customer_id = p_proj_customer_id
1649: AND a.agreement_id = f.agreement_id
1650: AND f.project_id = p_project_id
1651: AND ( f.total_unbaselined_amount <>0