APPS.PA_PROJECT_VERIFY_PKG dependencies on PA_PROJECT_CUSTOMERS

Line 54: FROM PA_PROJECT_CUSTOMERS

50: INTO dummy
51: FROM sys.dual
52: WHERE exists (
53: SELECT NULL
54: FROM PA_PROJECT_CUSTOMERS
55: WHERE PROJECT_ID = x_project_id
56: GROUP BY PROJECT_ID
57: HAVING SUM(CUSTOMER_BILL_SPLIT) = 100);
58: END IF;

Line 89: FROM PA_PROJECT_CUSTOMERS CUST

85: INTO dummy
86: FROM sys.dual
87: WHERE exists (
88: SELECT NULL
89: FROM PA_PROJECT_CUSTOMERS CUST
90: WHERE CUST.PROJECT_ID = x_project_id
91: AND CUST.CUSTOMER_BILL_SPLIT > 0
92: AND NOT EXISTS (SELECT NULL
93: FROM PA_PROJECT_CONTACTS CONT