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_ROLE_SOURCES

Line 1689: FROM OKC_ROLE_SOURCES

1685: l_api_name VARCHAR2(30) := 'CREATE_NEW_DEAL';
1686:
1687: CURSOR role_csr(p_rle_code VARCHAR2) IS
1688: SELECT access_level
1689: FROM OKC_ROLE_SOURCES
1690: WHERE rle_code = p_rle_code
1691: AND buy_or_sell = 'S';
1692:
1693: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

Line 1693: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

1689: FROM OKC_ROLE_SOURCES
1690: WHERE rle_code = p_rle_code
1691: AND buy_or_sell = 'S';
1692:
1693: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;
1694:
1695: --Bug# 4558486
1696: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
1697: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

Line 1950: FROM OKC_ROLE_SOURCES

1946: --end modified abhsaxen for performance SQLID 20562707
1947: ;
1948: CURSOR role_csr(p_rle_code VARCHAR2) IS
1949: SELECT access_level
1950: FROM OKC_ROLE_SOURCES
1951: WHERE rle_code = p_rle_code
1952: AND buy_or_sell = 'S';
1953:
1954: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

Line 1954: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

1950: FROM OKC_ROLE_SOURCES
1951: WHERE rle_code = p_rle_code
1952: AND buy_or_sell = 'S';
1953:
1954: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;
1955:
1956: --Bug# 4558486
1957: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
1958: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

Line 2235: FROM OKC_ROLE_SOURCES

2231: ;
2232:
2233: CURSOR role_csr(p_rle_code VARCHAR2) IS
2234: SELECT access_level
2235: FROM OKC_ROLE_SOURCES
2236: WHERE rle_code = p_rle_code
2237: AND buy_or_sell = 'S';
2238:
2239: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

Line 2239: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

2235: FROM OKC_ROLE_SOURCES
2236: WHERE rle_code = p_rle_code
2237: AND buy_or_sell = 'S';
2238:
2239: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;
2240:
2241: --Bug# 4558486
2242: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
2243: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

Line 2827: okc_role_sources rse,

2823: CURSOR c_rrdid_csr IS
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