APPS.PA_CUSTOMERS_CONTACTS_UTILS dependencies on PA_AGREEMENTS_ALL

Line 1236: /* BUG#2547423. Changed pa_agreements to pa_agreements_all */

1232: (SELECT null
1233: FROM pa_draft_invoices i
1234: WHERE i.project_id = c_project_id);
1235:
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

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 1250: FROM pa_agreements_all a,

1246: /*Added the below cursor for the enhancement 2520222*/
1247:
1248: CURSOR C2(c_project_id NUMBER, c_customer_id NUMBER) IS
1249: SELECT 'x'
1250: FROM pa_agreements_all a,
1251: pa_summary_project_fundings f
1252: WHERE a.customer_id = c_customer_id
1253: AND a.agreement_id = f.agreement_id
1254: AND f.project_id = c_project_id

Line 1320: /* BUG#2547423. Changed pa_agreements to pa_agreements_all */

1316: )
1317: IS
1318: c_exists VARCHAR2(1);
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

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