DBA Data[Home] [Help]

APPS.OKC_RENEW_PVT dependencies on OKC_ANCESTRYS

Line 3533: from okc_k_lines_b line, okc_ancestrys ans

3529: CLE_ID_ASCENDANT,
3530: LEVEL_SEQUENCE)
3531: select line.dnz_chr_id, ans.cle_id,
3532: ans.cle_id_ascendant, ans.level_sequence
3533: from okc_k_lines_b line, okc_ancestrys ans
3534: where line.id = ans.cle_id
3535: and line.dnz_chr_id = p_chr_id;
3536:
3537: -- To check whether any sublines are present

Line 3539: from okc_k_lines_b line, okc_ancestrys ans

3535: and line.dnz_chr_id = p_chr_id;
3536:
3537: -- To check whether any sublines are present
3538: select count(*) into l_top_count
3539: from okc_k_lines_b line, okc_ancestrys ans
3540: where line.id = ans.cle_id
3541: and line.dnz_chr_id = p_chr_id;
3542: -- If sublines are present
3543: If l_top_count > 0 Then