APPS.PA_INVOICE_CURRENCY dependencies on PA_SUMMARY_PROJECT_FUNDINGS

Line 280: FROM pa_summary_project_fundings

276: ELSIF l_invproc_currency_type ='FUNDING_CURRENCY' THEN
277:
278: /* SELECT funding_currency_code
279: INTO l_funding_currency_code
280: FROM pa_summary_project_fundings
281: WHERE project_id = p_project_id
282: AND rownum=1
283: GROUP BY funding_currency_code
284: HAVING sum(total_baselined_amount) <> 0; Commented for bug 3147272*/

Line 289: FROM pa_summary_project_fundings

285:
286: /* added the following select statement for bug 3147272*/
287: SELECT funding_currency_code
288: INTO l_funding_currency_code
289: FROM pa_summary_project_fundings
290: WHERE project_id = p_project_id
291: AND rownum=1
292: AND NVL(total_baselined_amount,0) > 0;
293:

Line 1229: FROM pa_summary_project_fundings

1225: ELSIF l_invproc_currency_type ='FUNDING_CURRENCY' THEN
1226:
1227: /* SELECT funding_currency_code
1228: INTO l_funding_currency_code
1229: FROM pa_summary_project_fundings
1230: WHERE project_id = p_project_id
1231: AND rownum=1
1232: GROUP BY funding_currency_code
1233: HAVING sum(total_baselined_amount) <> 0; Commented the code for bug 3147272*/

Line 1239: FROM pa_summary_project_fundings

1235: /* added the following select statement for bug 3147272 */
1236:
1237: SELECT funding_currency_code
1238: INTO l_funding_currency_code
1239: FROM pa_summary_project_fundings
1240: WHERE project_id = p_project_id
1241: AND rownum=1
1242: AND NVL(total_baselined_amount,0) > 0;
1243: