APPS.OKL_DEAL_CREATE_PUB dependencies on OKC_ROLE_SOURCES

Line 1690: FROM OKC_ROLE_SOURCES

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

Line 1694: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

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

Line 1951: FROM OKC_ROLE_SOURCES

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

Line 1955: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

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

Line 2236: FROM OKC_ROLE_SOURCES

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

Line 2240: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

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

Line 2847: okc_role_sources rse,

2843: CURSOR c_rrdid_csr IS
2844: SELECT rgrdfs.id
2845: FROM okc_k_headers_b CHR,
2846: okc_subclass_roles sre,
2847: okc_role_sources rse,
2848: okc_subclass_rg_defs rgdfs,
2849: okc_rg_role_defs rgrdfs
2850: WHERE CHR.id = p_dest_id
2851: AND sre.scs_code = CHR.scs_code