APPS.OKL_SEC_AGREEMENT_PVT dependencies on OKC_ROLE_SOURCES

Line 1589: FROM OKC_ROLE_SOURCES

1585:
1586:
1587: CURSOR role_csr(p_rle_code VARCHAR2) IS
1588: SELECT access_level
1589: FROM OKC_ROLE_SOURCES
1590: WHERE rle_code = p_rle_code
1591: AND buy_or_sell = 'S';
1592:
1593: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

Line 1593: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

1589: FROM OKC_ROLE_SOURCES
1590: WHERE rle_code = p_rle_code
1591: AND buy_or_sell = 'S';
1592:
1593: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;
1594:
1595: BEGIN
1596: -- Set API savepoint
1597: SAVEPOINT create_sec_agreement_PVT;

Line 2048: FROM OKC_ROLE_SOURCES

2044: -- end, mvasudev changes, 11/04/2003
2045:
2046: CURSOR role_csr(p_rle_code VARCHAR2) IS
2047: SELECT access_level
2048: FROM OKC_ROLE_SOURCES
2049: WHERE rle_code = p_rle_code
2050: AND buy_or_sell = 'S';
2051:
2052: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

Line 2052: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

2048: FROM OKC_ROLE_SOURCES
2049: WHERE rle_code = p_rle_code
2050: AND buy_or_sell = 'S';
2051:
2052: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;
2053:
2054:
2055: BEGIN
2056: -- Set API savepoint