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.OKC_CPL_PVT dependencies on OKC_SUBCLASS_ROLES

Line 922: ,okc_subclass_roles

918: cursor chr_csr is
919: select '!'
920: from
921: OKC_K_HEADERS_ALL_B -- Modified by jvorugan for Bug:4645341 OKC_K_HEADERS_B
922: ,okc_subclass_roles
923: where
924: okc_k_headers_all_b.id = p_cplv_rec.chr_id
925: and okc_subclass_roles.scs_code = okc_k_headers_all_b.scs_code
926: and okc_subclass_roles.rle_code = p_cplv_rec.rle_code

Line 925: and okc_subclass_roles.scs_code = okc_k_headers_all_b.scs_code

921: OKC_K_HEADERS_ALL_B -- Modified by jvorugan for Bug:4645341 OKC_K_HEADERS_B
922: ,okc_subclass_roles
923: where
924: okc_k_headers_all_b.id = p_cplv_rec.chr_id
925: and okc_subclass_roles.scs_code = okc_k_headers_all_b.scs_code
926: and okc_subclass_roles.rle_code = p_cplv_rec.rle_code
927: and sysdate between okc_subclass_roles.start_date
928: and NVL(okc_subclass_roles.end_date,sysdate)
929: ;

Line 926: and okc_subclass_roles.rle_code = p_cplv_rec.rle_code

922: ,okc_subclass_roles
923: where
924: okc_k_headers_all_b.id = p_cplv_rec.chr_id
925: and okc_subclass_roles.scs_code = okc_k_headers_all_b.scs_code
926: and okc_subclass_roles.rle_code = p_cplv_rec.rle_code
927: and sysdate between okc_subclass_roles.start_date
928: and NVL(okc_subclass_roles.end_date,sysdate)
929: ;
930: --

Line 927: and sysdate between okc_subclass_roles.start_date

923: where
924: okc_k_headers_all_b.id = p_cplv_rec.chr_id
925: and okc_subclass_roles.scs_code = okc_k_headers_all_b.scs_code
926: and okc_subclass_roles.rle_code = p_cplv_rec.rle_code
927: and sysdate between okc_subclass_roles.start_date
928: and NVL(okc_subclass_roles.end_date,sysdate)
929: ;
930: --
931: cursor cle_csr is

Line 928: and NVL(okc_subclass_roles.end_date,sysdate)

924: okc_k_headers_all_b.id = p_cplv_rec.chr_id
925: and okc_subclass_roles.scs_code = okc_k_headers_all_b.scs_code
926: and okc_subclass_roles.rle_code = p_cplv_rec.rle_code
927: and sysdate between okc_subclass_roles.start_date
928: and NVL(okc_subclass_roles.end_date,sysdate)
929: ;
930: --
931: cursor cle_csr is
932: select '!'

Line 941: select okc_subclass_roles.ID

937: okc_k_lines_b.ID = p_cplv_rec.cle_id
938: and okc_line_style_roles.LSE_ID = okc_k_lines_b.LSE_ID
939: and okc_line_style_roles.SRE_ID in
940: (
941: select okc_subclass_roles.ID
942: from
943: OKC_K_HEADERS_ALL_B -- Modified by jvorugan for Bug:4645341 OKC_K_HEADERS_B
944: ,okc_subclass_roles
945: where

Line 944: ,okc_subclass_roles

940: (
941: select okc_subclass_roles.ID
942: from
943: OKC_K_HEADERS_ALL_B -- Modified by jvorugan for Bug:4645341 OKC_K_HEADERS_B
944: ,okc_subclass_roles
945: where
946: okc_k_headers_all_b.id = p_cplv_rec.dnz_chr_id
947: and okc_subclass_roles.scs_code = okc_k_headers_all_b.scs_code
948: and okc_subclass_roles.rle_code = p_cplv_rec.rle_code

Line 947: and okc_subclass_roles.scs_code = okc_k_headers_all_b.scs_code

943: OKC_K_HEADERS_ALL_B -- Modified by jvorugan for Bug:4645341 OKC_K_HEADERS_B
944: ,okc_subclass_roles
945: where
946: okc_k_headers_all_b.id = p_cplv_rec.dnz_chr_id
947: and okc_subclass_roles.scs_code = okc_k_headers_all_b.scs_code
948: and okc_subclass_roles.rle_code = p_cplv_rec.rle_code
949: and sysdate between okc_subclass_roles.start_date
950: and NVL(okc_subclass_roles.end_date,sysdate)
951: )

Line 948: and okc_subclass_roles.rle_code = p_cplv_rec.rle_code

944: ,okc_subclass_roles
945: where
946: okc_k_headers_all_b.id = p_cplv_rec.dnz_chr_id
947: and okc_subclass_roles.scs_code = okc_k_headers_all_b.scs_code
948: and okc_subclass_roles.rle_code = p_cplv_rec.rle_code
949: and sysdate between okc_subclass_roles.start_date
950: and NVL(okc_subclass_roles.end_date,sysdate)
951: )
952: ;

Line 949: and sysdate between okc_subclass_roles.start_date

945: where
946: okc_k_headers_all_b.id = p_cplv_rec.dnz_chr_id
947: and okc_subclass_roles.scs_code = okc_k_headers_all_b.scs_code
948: and okc_subclass_roles.rle_code = p_cplv_rec.rle_code
949: and sysdate between okc_subclass_roles.start_date
950: and NVL(okc_subclass_roles.end_date,sysdate)
951: )
952: ;
953:

Line 950: and NVL(okc_subclass_roles.end_date,sysdate)

946: okc_k_headers_all_b.id = p_cplv_rec.dnz_chr_id
947: and okc_subclass_roles.scs_code = okc_k_headers_all_b.scs_code
948: and okc_subclass_roles.rle_code = p_cplv_rec.rle_code
949: and sysdate between okc_subclass_roles.start_date
950: and NVL(okc_subclass_roles.end_date,sysdate)
951: )
952: ;
953:
954: --commenting for Bug 3607178