DBA Data[Home] [Help]

APPS.OKS_WF_K_PROCESS_PVT dependencies on OKC_K_PARTY_ROLES_B

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