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 3058: FROM okl_ae_tmpt_lnes

3054: ,attribute12
3055: ,attribute13
3056: ,attribute14
3057: ,attribute15
3058: FROM okl_ae_tmpt_lnes
3059: WHERE avl_id = v_avl_id;
3060:
3061:
3062:

Line 3284: FROM OKL_AE_TMPT_LNES

3280: attribute12,
3281: attribute13,
3282: attribute14,
3283: attribute15
3284: FROM OKL_AE_TMPT_LNES
3285: WHERE avl_id = p_source_tmpl_id;
3286:
3287: atl_rec atl_csr%ROWTYPE;
3288: