APPS.OKL_STREAM_MIGRATION_PVT dependencies on OKL_AE_TEMPLATES

Line 2796: FROM OKL_AE_TEMPLATES

2792: last_updated_by,
2793: last_update_date,
2794: last_update_login,
2795: inv_code
2796: FROM OKL_AE_TEMPLATES
2797: WHERE OKL_AE_TEMPLATES.aes_id = p_aes_id;
2798:
2799: -- Cursor to select all template lines for a template
2800:

Line 2797: WHERE OKL_AE_TEMPLATES.aes_id = p_aes_id;

2793: last_update_date,
2794: last_update_login,
2795: inv_code
2796: FROM OKL_AE_TEMPLATES
2797: WHERE OKL_AE_TEMPLATES.aes_id = p_aes_id;
2798:
2799: -- Cursor to select all template lines for a template
2800:
2801: CURSOR atlv_pk_csr (p_avl_id IN NUMBER) IS

Line 2863: l_template_id okl_ae_templates.id%TYPE;

2859: l_deal_type okl_pdt_pqy_vals_uv.value%TYPE;
2860: l_tax_owner okl_pdt_pqy_vals_uv.value%TYPE;
2861:
2862: l_new_aes_id okl_ae_tmpt_sets.id%TYPE;
2863: l_template_id okl_ae_templates.id%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;

Line 2864: l_new_template_id okl_ae_templates.id%TYPE;

2860: l_tax_owner okl_pdt_pqy_vals_uv.value%TYPE;
2861:
2862: l_new_aes_id okl_ae_tmpt_sets.id%TYPE;
2863: l_template_id okl_ae_templates.id%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;