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_VENDOR_PROGRAM_PVT dependencies on OKC_SUBCLASS_ROLES

Line 31: FROM okc_role_sources rs, okc_subclass_roles sr

27:
28: --Murthy Added Cursors for JTOT OBJECT CODE and check for CONTRACT ID
29: CURSOR cur_jtot_object_code(p_rle_code IN VARCHAR2, p_scs_code IN VARCHAR2, p_buy_or_sell IN VARCHAR2) IS
30: SELECT jtot_object_code
31: FROM okc_role_sources rs, okc_subclass_roles sr
32: WHERE rs.rle_code = sr.rle_code AND SYSDATE BETWEEN rs.start_date AND NVL(rs.end_date,SYSDATE)
33: AND SYSDATE BETWEEN sr.start_date AND NVL(sr.end_date,SYSDATE)
34: AND rs.rle_code = p_rle_code
35: AND rs.buy_or_sell = p_buy_or_sell AND sr.scs_code = p_scs_code;

Line 117: FROM okc_role_sources rs, okc_subclass_roles sr

113:
114: /* --Murthy Added Cursors for JTOT OBJECT CODE and check for CONTRACT ID
115: CURSOR cur_jtot_object_code(p_rle_code IN VARCHAR2, p_scs_code IN VARCHAR2, p_buy_or_sell IN VARCHAR2) IS
116: SELECT jtot_object_code
117: FROM okc_role_sources rs, okc_subclass_roles sr
118: WHERE rs.rle_code = sr.rle_code AND SYSDATE BETWEEN rs.start_date AND NVL(rs.end_date,SYSDATE)
119: AND SYSDATE BETWEEN sr.start_date AND NVL(sr.end_date,SYSDATE)
120: AND rs.rle_code = p_rle_code
121: AND rs.buy_or_sell = p_buy_or_sell AND sr.scs_code = p_scs_code;