APPS.OKL_STREAMS_UTIL dependencies on OKL_STRM_TMPT_LINES_UV

Line 695: FROM OKL_STRM_TMPT_LINES_UV STL

691: WHERE id = l_khr_id;
692:
693: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
694: SELECT PRIMARY_STY_ID
695: FROM OKL_STRM_TMPT_LINES_UV STL
696: WHERE STL.PRIMARY_YN = 'Y'
697: AND STL.PDT_ID = l_pdt_id
698: AND (STL.START_DATE <= l_contract_start_date)
699: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 800: FROM OKL_STRM_TMPT_LINES_UV STL

796: WHERE id = l_khr_id;
797:
798: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
799: SELECT PRIMARY_STY_ID
800: FROM OKL_STRM_TMPT_LINES_UV STL
801: WHERE STL.PRIMARY_YN = 'Y'
802: AND STL.PDT_ID = l_pdt_id
803: AND (STL.START_DATE <= l_contract_start_date)
804: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 900: FROM OKL_STRM_TMPT_LINES_UV STL

896: AND khr.pdt_id = pdt.id;
897:
898: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
899: SELECT PRIMARY_STY_ID
900: FROM OKL_STRM_TMPT_LINES_UV STL
901: WHERE STL.PRIMARY_YN = 'Y'
902: AND STL.PDT_ID = l_pdt_id
903: AND (STL.START_DATE <= l_contract_start_date)
904: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 1006: FROM OKL_STRM_TMPT_LINES_UV STL

1002: AND khr.pdt_id = pdt.id;
1003:
1004: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
1005: SELECT PRIMARY_STY_ID
1006: FROM OKL_STRM_TMPT_LINES_UV STL
1007: WHERE STL.PRIMARY_YN = 'Y'
1008: AND STL.PDT_ID = l_pdt_id
1009: AND (STL.START_DATE <= l_contract_start_date)
1010: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 1106: FROM OKL_STRM_TMPT_LINES_UV STL

1102: WHERE id = l_khr_id;
1103:
1104: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1105: SELECT DEPENDENT_STY_ID
1106: FROM OKL_STRM_TMPT_LINES_UV STL
1107: WHERE PRIMARY_YN = 'N'
1108: AND STL.PDT_ID = l_product_id
1109: AND (STL.START_DATE <= l_contract_start_date)
1110: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 1210: FROM OKL_STRM_TMPT_LINES_UV STL

1206: WHERE id = l_khr_id;
1207:
1208: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1209: SELECT DEPENDENT_STY_ID
1210: FROM OKL_STRM_TMPT_LINES_UV STL
1211: WHERE PRIMARY_YN = 'N'
1212: AND STL.PDT_ID = l_product_id
1213: AND (STL.START_DATE <= l_contract_start_date)
1214: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 1318: FROM OKL_STRM_TMPT_LINES_UV STL

1314: WHERE id = l_khr_id;
1315:
1316: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1317: SELECT DEPENDENT_STY_ID
1318: FROM OKL_STRM_TMPT_LINES_UV STL
1319: WHERE PRIMARY_YN = 'N'
1320: AND STL.PDT_ID = l_product_id
1321: AND (STL.START_DATE <= l_contract_start_date)
1322: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 1415: FROM OKL_STRM_TMPT_LINES_UV STL

1411: AND khr.pdt_id = pdt.id;
1412:
1413: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1414: SELECT DEPENDENT_STY_ID
1415: FROM OKL_STRM_TMPT_LINES_UV STL
1416: WHERE PRIMARY_YN = 'N'
1417: AND STL.PDT_ID = l_product_id
1418: AND (STL.START_DATE <= l_contract_start_date)
1419: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 1520: FROM OKL_STRM_TMPT_LINES_UV STL

1516: AND khr.pdt_id = pdt.id;
1517:
1518: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1519: SELECT DEPENDENT_STY_ID
1520: FROM OKL_STRM_TMPT_LINES_UV STL
1521: WHERE PRIMARY_YN = 'N'
1522: AND STL.PDT_ID = l_product_id
1523: AND (STL.START_DATE <= l_contract_start_date)
1524: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 1629: FROM OKL_STRM_TMPT_LINES_UV STL

1625: AND khr.pdt_id = pdt.id;
1626:
1627: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1628: SELECT DEPENDENT_STY_ID
1629: FROM OKL_STRM_TMPT_LINES_UV STL
1630: WHERE PRIMARY_YN = 'N'
1631: AND STL.PDT_ID = l_product_id
1632: AND (STL.START_DATE <= l_contract_start_date)
1633: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)