DBA Data[Home] [Help]

APPS.OKS_WF_K_PROCESS_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 1392: HZ_CUST_ACCOUNT_ROLES CAR,

1388: -- Get quote To contact name
1389: CURSOR l_qtocontact_name_csr(p_chr_id NUMBER) IS
1390: select SUBSTRB(P.PERSON_LAST_NAME,1,50) || ', ' || SUBSTRB(P.PERSON_FIRST_NAME,1,40) name
1391: FROM OKS_K_HEADERS_B OKSH,
1392: HZ_CUST_ACCOUNT_ROLES CAR,
1393: HZ_PARTIES P,
1394: HZ_RELATIONSHIPS R
1395: WHERE OKSH.quote_to_contact_id = car.CUST_ACCOUNT_ROLE_ID
1396: AND CAR.ROLE_TYPE = 'CONTACT'