DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE1 dependencies on PA_CUSTOMERS_V

Line 3004: FROM PA_CUSTOMERS_V

3000: WHERE project_id = c_project_id;
3001:
3002: CURSOR l_check_org_csr (c_customer_id IN NUMBER) IS
3003: SELECT PARTY_ID
3004: FROM PA_CUSTOMERS_V
3005: WHERE CUSTOMER_ID = c_customer_id
3006: AND PARTY_TYPE = 'ORGANIZATION';
3007: BEGIN
3008:

Line 3721: FROM PA_CUSTOMERS_V

3717: and field_name = 'CUSTOMER_NAME');
3718:
3719: CURSOR l_check_org_csr (c_customer_id IN NUMBER) IS
3720: SELECT PARTY_ID
3721: FROM PA_CUSTOMERS_V
3722: WHERE CUSTOMER_ID = c_customer_id
3723: AND PARTY_TYPE = 'ORGANIZATION';
3724: BEGIN
3725: -- Bug 2984536. The customer records are created only if x_customer_id is null. Dont do processing