APPS.OKL_PROCESS_TMPT_SET_PVT dependencies on OKL_AE_TMPT_LNES

Line 686: FROM OKL_AE_TMPT_LNES

682: CREATION_DATE,
683: LAST_UPDATED_BY,
684: LAST_UPDATE_DATE,
685: LAST_UPDATE_LOGIN
686: FROM OKL_AE_TMPT_LNES
687: WHERE OKL_AE_TMPT_LNES.id = p_id;
688: l_okl_atlv_pk okl_atlv_pk_csr%ROWTYPE;
689: l_atlv_rec atlv_rec_type;
690: BEGIN

Line 687: WHERE OKL_AE_TMPT_LNES.id = p_id;

683: LAST_UPDATED_BY,
684: LAST_UPDATE_DATE,
685: LAST_UPDATE_LOGIN
686: FROM OKL_AE_TMPT_LNES
687: WHERE OKL_AE_TMPT_LNES.id = p_id;
688: l_okl_atlv_pk okl_atlv_pk_csr%ROWTYPE;
689: l_atlv_rec atlv_rec_type;
690: BEGIN
691: x_no_data_found := TRUE;

Line 916: FROM OKL_AE_TMPT_LNES

912: ATTRIBUTE12,
913: ATTRIBUTE13,
914: ATTRIBUTE14,
915: ATTRIBUTE15
916: FROM OKL_AE_TMPT_LNES
917: WHERE avl_id = v_avl_id;
918:
919: l_avlv_rec AVLV_REC_TYPE;
920: l_atlv_tbl ATLV_TBL_TYPE;

Line 1047: FROM OKL_AE_TMPT_LNES

1043: WHERE name = v_name;
1044:
1045: CURSOR atl_csr(v_id NUMBER) IS
1046: SELECT AVL_ID
1047: FROM OKL_AE_TMPT_LNES
1048: WHERE ID = v_id;
1049:
1050: l_avlv_rec AVLV_REC_TYPE;
1051: l_avlv_rec_out AVLV_REC_TYPE;

Line 2543: FROM OKL_AE_TMPT_LNES

2539: ATTRIBUTE12 ,
2540: ATTRIBUTE13 ,
2541: ATTRIBUTE14 ,
2542: ATTRIBUTE15
2543: FROM OKL_AE_TMPT_LNES
2544: WHERE ID = v_atl_id;
2545:
2546: CURSOR avl_csr(v_atl_id NUMBER) IS
2547: SELECT ID,

Line 2551: WHERE ID = (SELECT avl_id FROM OKL_AE_TMPT_LNES

2547: SELECT ID,
2548: start_date,
2549: end_date
2550: FROM OKL_AE_TEMPLATES
2551: WHERE ID = (SELECT avl_id FROM OKL_AE_TMPT_LNES
2552: WHERE ID = v_atl_id);
2553:
2554: l_start_date DATE;
2555: l_end_date DATE;

Line 3045: FROM okl_ae_tmpt_lnes

3041: ,attribute12
3042: ,attribute13
3043: ,attribute14
3044: ,attribute15
3045: FROM okl_ae_tmpt_lnes
3046: WHERE avl_id = v_avl_id;
3047:
3048:
3049:

Line 3268: FROM OKL_AE_TMPT_LNES

3264: attribute12,
3265: attribute13,
3266: attribute14,
3267: attribute15
3268: FROM OKL_AE_TMPT_LNES
3269: WHERE avl_id = p_source_tmpl_id;
3270:
3271: atl_rec atl_csr%ROWTYPE;
3272: