APPS.OKL_STREAM_MIGRATION_PVT dependencies on OKL_AE_TMPT_SETS_V

Line 2685: okl_ae_tmpt_sets_v aes,

2681: q2.value tax_owner,
2682: aes.name aes_name
2683: FROM
2684: okl_products_v p,
2685: okl_ae_tmpt_sets_v aes,
2686: okl_pdt_pqy_vals_uv q1,
2687: okl_pdt_pqy_vals_uv q2
2688: WHERE
2689: p.aes_id = aes.id AND

Line 2704: okl_ae_tmpt_sets_v aes,

2700: 'LESSEE' tax_owner,
2701: aes.name aes_name
2702: FROM
2703: okl_products_v p,
2704: okl_ae_tmpt_sets_v aes,
2705: okl_pdt_pqy_vals_uv q1
2706: WHERE
2707: p.aes_id = aes.id AND
2708: aes.gts_id IS NULL AND

Line 2746: FROM okl_ae_tmpt_sets_v

2742: last_updated_by,
2743: last_update_date,
2744: last_update_login,
2745: gts_id
2746: FROM okl_ae_tmpt_sets_v
2747: WHERE okl_ae_tmpt_sets_v.id = p_id;
2748:
2749: -- Cursor to get all the templates for a template set.
2750:

Line 2747: WHERE okl_ae_tmpt_sets_v.id = p_id;

2743: last_update_date,
2744: last_update_login,
2745: gts_id
2746: FROM okl_ae_tmpt_sets_v
2747: WHERE okl_ae_tmpt_sets_v.id = p_id;
2748:
2749: -- Cursor to get all the templates for a template set.
2750:
2751: CURSOR avlv_pk_csr (p_aes_id IN NUMBER) IS

Line 2868: l_old_aes_name okl_ae_tmpt_sets_v.name%TYPE;

2864: l_new_template_id okl_ae_templates.id%TYPE;
2865:
2866: l_gts_id OKL_ST_GEN_TMPT_SETS.id%TYPE;
2867: l_gts_name OKL_ST_GEN_TMPT_SETS.name%TYPE;
2868: l_old_aes_name okl_ae_tmpt_sets_v.name%TYPE;
2869:
2870: l_row_found VARCHAR2(1000);
2871: l_template_set_found VARCHAR2(1);
2872: l_templates_found VARCHAR2(1);