DBA Data[Home] [Help]

APPS.PA_CUSTOMERS_CONTACTS_UTILS dependencies on PA_PROJECT_FUNDINGS

Line 1240: FROM pa_agreements_all a, pa_project_fundings f

1236: /* BUG#2547423. Changed pa_agreements to pa_agreements_all */
1237: /*Commented the below code for enhancement 2520222*/
1238: /*CURSOR C2(c_project_id NUMBER, c_customer_id NUMBER) IS
1239: SELECT 'x'
1240: FROM pa_agreements_all a, pa_project_fundings f
1241: WHERE a.customer_id+0 = c_customer_id AND
1242: a.agreement_id = f.agreement_id AND
1243: f.project_id = c_project_id AND
1244: f.budget_type_code = 'BASELINE';*/

Line 1323: FROM pa_agreements_all a, pa_project_fundings f

1319:
1320: /* BUG#2547423. Changed pa_agreements to pa_agreements_all */
1321: CURSOR C(c_project_id NUMBER, c_customer_id NUMBER) IS
1322: SELECT 'x'
1323: FROM pa_agreements_all a, pa_project_fundings f
1324: WHERE a.customer_id+0 = c_customer_id AND
1325: a.agreement_id = f.agreement_id AND
1326: f.project_id = c_project_id;
1327: BEGIN