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_RG_DEFS

Line 1160: FROM okc_rule_groups_b rgp, okc_subclass_rg_defs rg_defs

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

Line 2755: FROM okc_subclass_rg_defs rgdfs

2751: AND hdr.id = rg.dnz_chr_id
2752: AND rg.cle_id IS NULL
2753: AND EXISTS
2754: (SELECT '1'
2755: FROM okc_subclass_rg_defs rgdfs
2756: WHERE rgdfs.rgd_code = rg.rgd_code
2757: AND rgdfs.scs_code = 'LEASE')
2758: AND NOT EXISTS
2759: (SELECT '1'

Line 2845: okc_subclass_rg_defs rgdfs,

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
2848: AND sre.scs_code = CHR.scs_code
2849: AND sre.rle_code = rse.rle_code