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 2738: FROM okc_subclass_rg_defs rgdfs

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

Line 2828: okc_subclass_rg_defs rgdfs,

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