APPS.OKL_STREAM_MIGRATION_PVT dependencies on OKL_SGN_TRANSLATIONS

Line 542: FROM okl_sgn_translations sgn

538: -- Cursor to find if a stream type is used in Subsidy.
539:
540: CURSOR subsidy_inc_csr (l_sty_id NUMBER) IS
541: SELECT '1'
542: FROM okl_sgn_translations sgn
543: WHERE sgn.jtot_object1_code = 'OKL_STRMTYP' AND
544: sgn.value = TO_CHAR(l_sty_id);
545:
546: BEGIN

Line 1380: FROM OKL_STRM_TYPE_V STY, okl_sgn_translations sgn

1376: 'SERVICE AND MAINTENANCE EVERGREEN');
1377:
1378: CURSOR subsidy_csr IS
1379: SELECT STY.ID, STY.CODE , STY.stream_type_purpose
1380: FROM OKL_STRM_TYPE_V STY, okl_sgn_translations sgn
1381: WHERE sgn.object1_id1 = TO_CHAR(p_sty_id)
1382: AND sgn.value = TO_CHAR(sty.id);
1383:
1384: l_dep_sty_tbl dep_sty_tbl;