APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_AGREEMENTS

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

1397: /* Code addition for bug 2872748 ends */
1398:
1399: SELECT 'N' INTO lv_return_flag FROM DUAL
1400: WHERE EXISTS ( SELECT a.agreement_id
1401: FROM pa_agreements a
1402: WHERE a.agreement_currency_code <> l_currency_code);
1403: /* for bug 2872748 replaced pa_currency.get_currency_code with l_currency_code in above sql */
1404:
1405: RETURN (lv_return_flag);

Line 1646: FROM pa_agreements a,

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