APPS.OKS_WF_K_PROCESS_PVT dependencies on HZ_PARTIES

Line 419: FROM OKC_K_PARTY_ROLES_B a, hz_parties b

415: WHERE fndu.user_id = p_user_id;
416:
417: CURSOR l_party_csr(p_chr_id NUMBER) IS
418: SELECT b.party_name
419: FROM OKC_K_PARTY_ROLES_B a, hz_parties b
420: WHERE a.dnz_chr_id = p_chr_id
421: AND a.object1_id1 = b.party_id;
422:
423: CURSOR l_kdetails_csr(p_chr_id NUMBER) IS

Line 1362: FROM OKC_K_PARTY_ROLES_B a, hz_parties b

1358: l_api_name CONSTANT VARCHAR2(50) := 'set_notification_attributes';
1359:
1360: CURSOR l_party_csr(p_chr_id NUMBER) IS
1361: SELECT b.party_name
1362: FROM OKC_K_PARTY_ROLES_B a, hz_parties b
1363: WHERE a.dnz_chr_id = p_chr_id
1364: AND a.object1_id1 = b.party_id;
1365:
1366: CURSOR l_kdetails_csr(p_chr_id NUMBER) IS

Line 1393: HZ_PARTIES P,

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'
1397: AND R.PARTY_ID = CAR.PARTY_ID

Line 1965: FROM OKC_K_PARTY_ROLES_B a, hz_parties b

1961: WHERE fndu.user_id = p_user_id;
1962:
1963: CURSOR l_party_csr(p_chr_id NUMBER) IS
1964: SELECT b.party_name
1965: FROM OKC_K_PARTY_ROLES_B a, hz_parties b
1966: WHERE a.dnz_chr_id = p_chr_id
1967: AND a.object1_id1 = b.party_id;
1968:
1969: CURSOR l_kdetails_csr(p_chr_id NUMBER) IS