APPS.OKE_CONTRACT_PVT dependencies on OKE_K_STANDARD_NOTES_B

Line 716: from oke_k_standard_notes_b b, oke_k_standard_notes_tl t

712: t.sfwt_flag,
713: t.description,
714: t.name,
715: t.text
716: from oke_k_standard_notes_b b, oke_k_standard_notes_tl t
717: where k_line_id = p_id;
718: l_standard_notes l_standard_notes_csr%ROWTYPE;
719:
720:

Line 728: insert into oke_k_standard_notes_b

724:
725: for l_standard_notes in l_standard_notes_csr(p_line_id)
726: loop
727: select oke_k_standard_notes_s.nextval into l_id from dual;
728: insert into oke_k_standard_notes_b
729: (standard_notes_id,
730: creation_date,
731: created_by,
732: last_update_date,

Line 1419: from oke_k_standard_notes_bh

1415:
1416: delete from OKE_K_STANDARD_NOTES_TLH
1417: where standard_notes_id in(
1418: select standard_notes_id
1419: from oke_k_standard_notes_bh
1420: where k_header_id = p_header_id);
1421:
1422: delete from OKE_K_STANDARD_NOTES_BH
1423: where k_header_id = p_header_id;

Line 1422: delete from OKE_K_STANDARD_NOTES_BH

1418: select standard_notes_id
1419: from oke_k_standard_notes_bh
1420: where k_header_id = p_header_id);
1421:
1422: delete from OKE_K_STANDARD_NOTES_BH
1423: where k_header_id = p_header_id;
1424:
1425:
1426: