APPS.OKE_DEFAULTING_PKG dependencies on OKC_ANCESTRYS

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

275: where dnz_chr_id = p_header_id and chr_id = p_id
276: and rle_code = p_code;
277:
278: cursor line_party(p_code Varchar2) is
279: select Max(a.level_sequence) from okc_ancestrys a
280: where a.cle_id = p_line_id
281: and exists(select 'x' from okc_k_party_roles_b b where dnz_chr_id = p_header_id and b.cle_id = a.cle_id_ascendant and b.rle_code = p_code and object1_id1 is not null);
282:
283: cursor header_party(p_code Varchar2) is

Line 294: select 'x' from okc_ancestrys

290: select buy_or_sell from okc_k_headers_b
291: where id = p_header_id;
292:
293: cursor top_line is
294: select 'x' from okc_ancestrys
295: where cle_id = p_line_id;
296:
297: Cursor Inv_C(P_Id Number) Is
298: Select 'x'

Line 387: from okc_ancestrys

383:
384: -- check parent line default
385:
386: select cle_id_ascendant into l_id
387: from okc_ancestrys
388: where cle_id = p_line_id
389: and level_sequence = l_level;
390:
391: select count(*) into l_row_count

Line 520: from okc_ancestrys

516:
517: -- check parent line default
518:
519: select cle_id_ascendant into l_id
520: from okc_ancestrys
521: where cle_id = p_line_id
522: and level_sequence = l_level;
523:
524: select count(*) into l_row_count