APPS.PA_PROJECT_UTILS dependencies on PA_PROJECT_CUSTOMERS

Line 394: from pa_project_customers

390: , x_rowid IN varchar2 ) return number
391: is
392: cursor c1 is
393: select 1
394: from pa_project_customers
395: where project_id = x_project_id
396: AND customer_id = x_customer_id
397: AND (x_rowid is null
398: or x_rowid <> pa_project_customers.rowid);

Line 398: or x_rowid <> pa_project_customers.rowid);

394: from pa_project_customers
395: where project_id = x_project_id
396: AND customer_id = x_customer_id
397: AND (x_rowid is null
398: or x_rowid <> pa_project_customers.rowid);
399:
400: c1_rec c1%rowtype;
401:
402: begin

Line 524: FROM PA_PROJECT_CUSTOMERS

520: function check_bill_split (x_project_id IN number ) return number
521: is
522: cursor c1 is
523: SELECT NULL
524: FROM PA_PROJECT_CUSTOMERS
525: WHERE PROJECT_ID = x_PROJECT_ID
526: GROUP BY PROJECT_ID
527: HAVING SUM(CUSTOMER_BILL_SPLIT) = 100;
528:

Line 569: FROM PA_PROJECT_CUSTOMERS CUST

565: cursor c1 is
566: select 1
567: from sys.dual
568: where exists (SELECT NULL
569: FROM PA_PROJECT_CUSTOMERS CUST
570: WHERE CUST.PROJECT_ID = x_project_id
571: AND CUST.CUSTOMER_BILL_SPLIT > 0
572: AND EXISTS (SELECT NULL
573: FROM PA_PROJECT_CONTACTS CONT

Line 2098: FROM PA_PROJECT_CUSTOMERS

2094: CURSOR c1 is
2095: SELECT 'Y'
2096: FROM DUAL
2097: WHERE EXISTS (SELECT 'Y'
2098: FROM PA_PROJECT_CUSTOMERS
2099: WHERE project_id = p_project_id
2100: AND (customer_id <> bill_to_customer_id
2101: OR customer_id <> ship_to_customer_id )) ;
2102: c1_rec c1%rowtype ;