APPS.PA_PROJECT_CORE dependencies on PA_PROJECT_CUSTOMERS

Line 331: delete from pa_project_customers

327: delete from pa_project_classes
328: where project_id = x_project_id;
329:
330: -- Delete project customers
331: delete from pa_project_customers
332: where project_id = x_project_id;
333:
334: -- Delete project contacts
335: delete from pa_project_contacts

Line 1282: FROM pa_project_customers

1278: FROM ra_addresses A, ra_site_uses SU
1279: WHERE A.address_id = SU.address_id
1280: AND A.customer_id IN
1281: (SELECT customer_id
1282: FROM pa_project_customers
1283: WHERE project_id = x_project_id)
1284: AND NVL(SU.STATUS,'A') = 'A'
1285: AND SU.site_use_code = 'SHIP_TO';
1286: */

Line 1297: (SELECT customer_id FROM pa_project_customers WHERE project_id = x_project_id)

1293: hz_cust_site_uses su
1294: WHERE
1295: acct_site.cust_acct_site_id = su.cust_acct_site_id
1296: AND acct_site.cust_account_id IN
1297: (SELECT customer_id FROM pa_project_customers WHERE project_id = x_project_id)
1298: AND NVL(SU.STATUS,'A') = 'A'
1299: AND SU.site_use_code = 'SHIP_TO';
1300:
1301: -- 4363092 end