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_CREAT_PVT dependencies on OKC_SUBCLASS_RG_DEFS

Line 1159: FROM okc_rule_groups_b rgp, okc_subclass_rg_defs rg_defs

1155: AND id = p_id;
1156:
1157: CURSOR c_rgpv IS
1158: SELECT rgp.id
1159: FROM okc_rule_groups_b rgp, okc_subclass_rg_defs rg_defs
1160: WHERE rgp.dnz_chr_id = p_source_chr_id
1161: AND rgp.rgd_code = rg_defs.rgd_code
1162: AND rg_defs.scs_code = 'LEASE'
1163: AND rgp.cle_id IS NULL

Line 2735: FROM okc_subclass_rg_defs rgdfs

2731: AND hdr.id = rg.dnz_chr_id
2732: AND rg.cle_id IS NULL
2733: AND EXISTS
2734: (SELECT '1'
2735: FROM okc_subclass_rg_defs rgdfs
2736: WHERE rgdfs.rgd_code = rg.rgd_code
2737: AND rgdfs.scs_code = 'LEASE')
2738: AND NOT EXISTS
2739: (SELECT '1'

Line 2825: okc_subclass_rg_defs rgdfs,

2821: SELECT rgrdfs.id
2822: FROM okc_k_headers_b CHR,
2823: okc_subclass_roles sre,
2824: okc_role_sources rse,
2825: okc_subclass_rg_defs rgdfs,
2826: okc_rg_role_defs rgrdfs
2827: WHERE CHR.id = p_dest_id
2828: AND sre.scs_code = CHR.scs_code
2829: AND sre.rle_code = rse.rle_code