APPS.PA_INVOICE_CURRENCY dependencies on PA_SUMMARY_PROJECT_FUNDINGS

Line 257: FROM pa_summary_project_fundings

253: ELSIF l_invproc_currency_type ='FUNDING_CURRENCY' THEN
254:
255: /* SELECT funding_currency_code
256: INTO l_funding_currency_code
257: FROM pa_summary_project_fundings
258: WHERE project_id = p_project_id
259: AND rownum=1
260: GROUP BY funding_currency_code
261: HAVING sum(total_baselined_amount) <> 0; Commented for bug 3147272*/

Line 266: FROM pa_summary_project_fundings

262:
263: /* added the following select statement for bug 3147272*/
264: SELECT funding_currency_code
265: INTO l_funding_currency_code
266: FROM pa_summary_project_fundings
267: WHERE project_id = p_project_id
268: AND rownum=1
269: AND NVL(total_baselined_amount,0) > 0;
270:

Line 1065: FROM pa_summary_project_fundings

1061: ELSIF l_invproc_currency_type ='FUNDING_CURRENCY' THEN
1062:
1063: /* SELECT funding_currency_code
1064: INTO l_funding_currency_code
1065: FROM pa_summary_project_fundings
1066: WHERE project_id = p_project_id
1067: AND rownum=1
1068: GROUP BY funding_currency_code
1069: HAVING sum(total_baselined_amount) <> 0; Commented the code for bug 3147272*/

Line 1075: FROM pa_summary_project_fundings

1071: /* added the following select statement for bug 3147272 */
1072:
1073: SELECT funding_currency_code
1074: INTO l_funding_currency_code
1075: FROM pa_summary_project_fundings
1076: WHERE project_id = p_project_id
1077: AND rownum=1
1078: AND NVL(total_baselined_amount,0) > 0;
1079: