DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE1 dependencies on PA_CUSTOMERS_V

Line 3047: FROM PA_CUSTOMERS_V

3043: WHERE project_id = c_project_id;
3044:
3045: CURSOR l_check_org_csr (c_customer_id IN NUMBER) IS
3046: SELECT PARTY_ID
3047: FROM PA_CUSTOMERS_V
3048: WHERE CUSTOMER_ID = c_customer_id
3049: AND PARTY_TYPE = 'ORGANIZATION';
3050: BEGIN
3051:

Line 3764: FROM PA_CUSTOMERS_V

3760: and field_name = 'CUSTOMER_NAME');
3761:
3762: CURSOR l_check_org_csr (c_customer_id IN NUMBER) IS
3763: SELECT PARTY_ID
3764: FROM PA_CUSTOMERS_V
3765: WHERE CUSTOMER_ID = c_customer_id
3766: AND PARTY_TYPE = 'ORGANIZATION';
3767: BEGIN
3768: -- Bug 2984536. The customer records are created only if x_customer_id is null. Dont do processing