eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_DEAL_CREATE_PUB dependencies on OKC_SUBCLASS_ROLES

Line 1187: FROM okc_k_party_roles_b cpl, okc_subclass_roles ROLES

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

Line 2843: okc_subclass_roles sre,

2839:
2840: CURSOR c_rrdid_csr IS
2841: SELECT rgrdfs.id
2842: FROM okc_k_headers_b CHR,
2843: okc_subclass_roles sre,
2844: okc_role_sources rse,
2845: okc_subclass_rg_defs rgdfs,
2846: okc_rg_role_defs rgrdfs
2847: WHERE CHR.id = p_dest_id