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 1296: FROM pa_project_customers

1292: FROM ra_addresses A, ra_site_uses SU
1293: WHERE A.address_id = SU.address_id
1294: AND A.customer_id IN
1295: (SELECT customer_id
1296: FROM pa_project_customers
1297: WHERE project_id = x_project_id)
1298: AND NVL(SU.STATUS,'A') = 'A'
1299: AND SU.site_use_code = 'SHIP_TO';
1300: */

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

1307: hz_cust_site_uses su
1308: WHERE
1309: acct_site.cust_acct_site_id = su.cust_acct_site_id
1310: AND acct_site.cust_account_id IN
1311: (SELECT customer_id FROM pa_project_customers WHERE project_id = x_project_id)
1312: AND NVL(SU.STATUS,'A') = 'A'
1313: AND SU.site_use_code = 'SHIP_TO';
1314:
1315: -- 4363092 end