APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_AGREEMENTS

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 1408: FROM pa_agreements a

1404: /* Code addition for bug 2872748 ends */
1405:
1406: SELECT 'N' INTO lv_return_flag FROM DUAL
1407: WHERE EXISTS ( SELECT a.agreement_id
1408: FROM pa_agreements a
1409: WHERE a.agreement_currency_code <> l_currency_code);
1410: /* for bug 2872748 replaced pa_currency.get_currency_code with l_currency_code in above sql */
1411:
1412: RETURN (lv_return_flag);

Line 1653: FROM pa_agreements a,

1649: )
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