DBA Data[Home] [Help]

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 2056: FROM OKC_ROLE_SOURCES

2052: -- end, mvasudev changes, 11/04/2003
2053:
2054: CURSOR role_csr(p_rle_code VARCHAR2) IS
2055: SELECT access_level
2056: FROM OKC_ROLE_SOURCES
2057: WHERE rle_code = p_rle_code
2058: AND buy_or_sell = 'S';
2059:
2060: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

Line 2060: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

2056: FROM OKC_ROLE_SOURCES
2057: WHERE rle_code = p_rle_code
2058: AND buy_or_sell = 'S';
2059:
2060: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;
2061:
2062:
2063: BEGIN
2064: -- Set API savepoint