APPS.OKC_RENEW_PVT dependencies on OKC_UPD_REN_TEMP

Line 3493: FROM OKC_UPD_REN_TEMP

3489:
3490: -- To get the distinct cle_id_ascendant for that particular level
3491: CURSOR ancestry_cle_id( l_level NUMBER) IS
3492: SELECT distinct(cle_id_ascendant)
3493: FROM OKC_UPD_REN_TEMP
3494: WHERE level_sequence = l_level;
3495: Begin
3496:
3497: IF (l_debug = 'Y') THEN

Line 3525: okc_debug.log('13400: Before Insert Into OKC_UPD_REN_TEMP');

3521: end if;
3522:
3523: -- Inserting into temporary table
3524: IF (l_debug = 'Y') THEN
3525: okc_debug.log('13400: Before Insert Into OKC_UPD_REN_TEMP');
3526: END IF;
3527: insert into OKC_UPD_REN_TEMP(DNZ_CHR_ID,
3528: CLE_ID,
3529: CLE_ID_ASCENDANT,

Line 3527: insert into OKC_UPD_REN_TEMP(DNZ_CHR_ID,

3523: -- Inserting into temporary table
3524: IF (l_debug = 'Y') THEN
3525: okc_debug.log('13400: Before Insert Into OKC_UPD_REN_TEMP');
3526: END IF;
3527: insert into OKC_UPD_REN_TEMP(DNZ_CHR_ID,
3528: CLE_ID,
3529: CLE_ID_ASCENDANT,
3530: LEVEL_SEQUENCE)
3531: select line.dnz_chr_id, ans.cle_id,

Line 3546: from OKC_UPD_REN_TEMP

3542: -- If sublines are present
3543: If l_top_count > 0 Then
3544: -- Get the maximum level sequence
3545: select MAX(level_sequence) into l_level
3546: from OKC_UPD_REN_TEMP
3547: where dnz_chr_id = p_chr_id;
3548:
3549: While (l_level > 0)
3550: Loop