DBA Data[Home] [Help]

APPS.OKL_DEAL_CREAT_PVT dependencies on OKC_SUBCLASS_ROLES

Line 1186: FROM okc_k_party_roles_b cpl, okc_subclass_roles ROLES

1182: AND cle_id IS NULL;
1183:
1184: CURSOR c_cplv IS
1185: SELECT cpl.id
1186: FROM okc_k_party_roles_b cpl, okc_subclass_roles ROLES
1187: WHERE dnz_chr_id = p_source_chr_id
1188: AND cpl.rle_code = ROLES.rle_code
1189: AND ROLES.scs_code = 'LEASE'
1190: AND cpl.cle_id IS NULL;

Line 2826: okc_subclass_roles sre,

2822:
2823: CURSOR c_rrdid_csr IS
2824: SELECT rgrdfs.id
2825: FROM okc_k_headers_b CHR,
2826: okc_subclass_roles sre,
2827: okc_role_sources rse,
2828: okc_subclass_rg_defs rgdfs,
2829: okc_rg_role_defs rgrdfs
2830: WHERE CHR.id = p_dest_id