APPS.OKC_TERMS_DEVIATIONS_PVT dependencies on OKC_SECTIONS_B

Line 375: okc_sections_b where id = odt.scn_id)

371: END IF;
372: /*
373: Update okc_terms_deviations_t odt set
374: (odt.scn_label, odt.scn_sequence) = (select label, section_sequence from
375: okc_sections_b where id = odt.scn_id)
376: where sequence_id = p_sequence_id;
377: */
378:
379: /* bug #4057194

Line 414: from okc_sections_b osb1, okc_sections_b osb2

410: (odt.scn_label, odt.scn_sequence) =
411: (select osb1.label, decode(osb1.section_sequence,
412: osb2.section_sequence,osb1.section_sequence,
413: osb2.section_sequence+(1/10000)*osb1.section_sequence) -- Bug#4615605 replaced .0001 with 1/10000
414: from okc_sections_b osb1, okc_sections_b osb2
415: where nvl(osb1.scn_id,osb1.id) = osb2.id
416: and osb1.document_type = odt.document_type
417: and osb1.document_id = odt.document_id
418: and osb1.id = odt.scn_id)

Line 430: from okc_sections_b osb1, okc_sections_b osb2, okc_sections_b osb3

426: (odt.scn_label, odt.scn_sequence) = (select osb1.label,
427: decode(osb1.section_sequence,
428: osb2.section_sequence,osb1.section_sequence,
429: osb2.section_sequence+(1/10000)*osb1.section_sequence)
430: from okc_sections_b osb1, okc_sections_b osb2, okc_sections_b osb3
431: where nvl(osb1.scn_id,osb1.id) = osb2.id
432: and osb1.document_type = odt.document_type
433: and osb1.document_id = odt.document_id
434: and osb3.id = odt.scn_id

Line 454: from okc_sections_b osb1, okc_sections_b osb2

450: (select osb1.label, to_number(decode(osb1.section_sequence,
451: osb2.section_sequence,osb1.section_sequence,
452: osb2.section_sequence+(1/10000)*osb1.section_sequence))
453: + l_max_scn_seq
454: from okc_sections_b osb1, okc_sections_b osb2
455: where nvl(osb1.scn_id,osb1.id) = osb2.id
456: and osb1.document_type = 'TEMPLATE'
457: and osb1.id = odt.scn_id)
458: where sequence_id = p_sequence_id