APPS.OKL_STREAM_MIGRATION_PVT dependencies on OKL_STRM_TYPE_B

Line 731: okl_strm_type_b WHERE code = 'RENT')

727: AND lseb.lty_code = 'FREE_FORM1'
728: AND cleb.chr_id = chrb.id
729: AND chrb.scs_code IN ('LEASE','QUOTE')
730: AND rul.object1_id1 NOT IN (SELECT id FROM
731: okl_strm_type_b WHERE code = 'RENT')
732: AND chrb.id = khr.id
733: AND khr.pdt_id = pdt.id
734: AND rul.object1_id1 = l_sty_id
735: AND pdt.deal_type IN ('LEASEOP', 'LEASEDF', 'LEASEST', 'LOAN', 'LOAN-REVOLVING', 'SALE')

Line 849: UPDATE OKL_STRM_TYPE_B

845: -- Update stream type with proper purpose
846: IF l_new_sty_purpose IS NOT NULL THEN
847: Fnd_File.put_line(Fnd_File.LOG,'Updating Stream Type Purpose of Stream Type - ' || strm_type_rec.name || ' to - ' || l_new_sty_purpose);
848: BEGIN
849: UPDATE OKL_STRM_TYPE_B
850: SET STREAM_TYPE_PURPOSE =l_new_sty_purpose,
851: LAST_UPDATE_DATE = SYSDATE,
852: LAST_UPDATE_LOGIN = Fnd_Global.login_id
853: WHERE ID = strm_type_rec.id;

Line 1153: okl_strm_type_b WHERE code = 'RENT')

1149: AND lseb.lty_code = 'FREE_FORM1'
1150: AND cleb.chr_id = chrb.id
1151: AND chrb.scs_code IN ('LEASE','QUOTE')
1152: AND rul.object1_id1 NOT IN (SELECT id FROM
1153: okl_strm_type_b WHERE code = 'RENT')
1154: AND rul.object1_id1 = p_sty_id
1155: AND chrb.id = khr.id
1156: AND khr.pdt_id = pdt.id
1157: AND pdt.DEAL_TYPE = p_book_class

Line 1324: FROM okl_strm_type_b

1320: IS
1321:
1322: CURSOR primary_sty_csr IS
1323: SELECT id, code, stream_type_purpose
1324: FROM okl_strm_type_b
1325: WHERE id = p_sty_id;
1326:
1327: CURSOR act_prpty_tax_csr IS
1328: SELECT ID, CODE , stream_type_purpose

Line 1385: l_sty_purpose OKL_STRM_TYPE_B.stream_type_purpose%TYPE;

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;
1385: l_sty_purpose OKL_STRM_TYPE_B.stream_type_purpose%TYPE;
1386:
1387: j NUMBER := 0;
1388:
1389: BEGIN

Line 1540: FROM okl_strm_type_b

1536: IS
1537:
1538: CURSOR sty_id_csr IS
1539: SELECT id
1540: FROM okl_strm_type_b
1541: WHERE code = p_sty_code
1542: AND stream_type_purpose = p_sty_purpose;
1543:
1544: l_sty_id NUMBER;