APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_PROD_STRM_TYPES_V

Line 233: FROM okl_prod_strm_types_v psyv

229: l_del_psyv_tbl Okl_Pdt_Stys_Pub.psyv_tbl_type;
230:
231: CURSOR psy_csr IS
232: SELECT psyv.id
233: FROM okl_prod_strm_types_v psyv
234: WHERE psyv.pdt_id = p_pdtv_rec.id;
235:
236: BEGIN
237:

Line 353: Okl_Prod_Strm_Types_v psy

349: NVL(ove.TO_DATE, p_to_date) < p_to_date);
350: /* UNION ALL
351: SELECT '4'
352: FROM Okl_Strm_Type_b sty,
353: Okl_Prod_Strm_Types_v psy
354: WHERE psy.PDT_ID = p_pdt_id
355: AND psy.sty_id = sty.ID
356: AND ((sty.START_DATE > p_from_date OR
357: p_from_date > NVL(sty.END_DATE,p_from_date)) OR

Line 522: okl_prod_strm_types_v psy

518: SELECT COUNT(aes.id)
519: INTO l_pdt_psy_changed
520: FROM
521: okl_ae_tmpt_sets_v aes,
522: okl_prod_strm_types_v psy
523: WHERE aes.id = p_db_pdtv_rec.aes_id
524: and psy.pdt_id = p_upd_pdtv_rec.id;
525:
526: -- check to see if the product already has a streams attached to it , if yes delete the

Line 3315: CURSOR okl_psyv_fk_csr (p_pdt_id IN Okl_prod_strm_types_V.pdt_id%TYPE) IS

3311: x_return_status OUT NOCOPY VARCHAR2,
3312: x_count OUT NOCOPY NUMBER,
3313: x_psyv_tbl OUT NOCOPY psyv_tbl_type
3314: ) IS
3315: CURSOR okl_psyv_fk_csr (p_pdt_id IN Okl_prod_strm_types_V.pdt_id%TYPE) IS
3316: SELECT ID,
3317: PDT_ID,
3318: STY_ID,
3319: ACCRUAL_YN,

Line 3322: FROM Okl_prod_strm_types_V psy

3318: STY_ID,
3319: ACCRUAL_YN,
3320: FROM_DATE,
3321: TO_DATE
3322: FROM Okl_prod_strm_types_V psy
3323: WHERE psy.PDT_ID = p_pdt_id;
3324:
3325: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3326: l_count NUMBER := 0;