APPS.OKE_CONTRACT_PUB dependencies on OKC_ANCESTRYS

Line 3316: select Max(a.level_sequence) from okc_ancestrys a

3312: where dnz_chr_id = p_id and chr_id = p_id
3313: and rle_code = p_code;
3314:
3315: cursor line_party(p_code Varchar2) is
3316: select Max(a.level_sequence) from okc_ancestrys a
3317: where a.cle_id = p_line_id
3318: and exists(select 'x' from okc_k_party_roles_b b where b.cle_id = a.cle_id_ascendant and b.rle_code = p_code and object1_id1 is not null);
3319:
3320: cursor header_party(p_code Varchar2) is

Line 3331: select 'x' from okc_ancestrys

3327: select buy_or_sell from okc_k_headers_b
3328: where id = p_header_id;
3329:
3330: cursor top_line is
3331: select 'x' from okc_ancestrys
3332: where cle_id = p_line_id;
3333:
3334: Cursor Inv_C(P_Id Number) Is
3335: Select 'x'

Line 3419: from okc_ancestrys

3415: if l_level is not null then
3416:
3417: -- check parent line default
3418: select cle_id_ascendant into l_id
3419: from okc_ancestrys
3420: where cle_id = p_line_id
3421: and level_sequence = l_level;
3422:
3423: select count(*) into l_row_count

Line 3541: from okc_ancestrys

3537: if l_level is not null then
3538:
3539: -- check parent line default
3540: select cle_id_ascendant into l_id
3541: from okc_ancestrys
3542: where cle_id = p_line_id
3543: and level_sequence = l_level;
3544:
3545: select count(*) into l_row_count