DBA Data[Home] [Help]

APPS.PA_PROJECT_VERIFY_PKG dependencies on PA_PROJECT_CONTACTS

Line 101: FROM PA_PROJECT_CONTACTS CONT

97: FROM PA_PROJECT_CUSTOMERS CUST
98: WHERE CUST.PROJECT_ID = x_project_id
99: AND CUST.CUSTOMER_BILL_SPLIT > 0
100: AND NOT EXISTS (SELECT NULL
101: FROM PA_PROJECT_CONTACTS CONT
102: WHERE CONT.PROJECT_ID = x_project_id
103: AND CONT.CUSTOMER_ID= CUST.CUSTOMER_ID
104: AND CONT.PROJECT_CONTACT_TYPE_CODE = 'BILLING'));
105: x_err_code := 10;