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:
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