APPS.OKE_IMPORT_CONTRACT_PUB dependencies on OKE_K_STANDARD_NOTES_B

Line 3680: (select standard_notes_id from oke_k_standard_notes_b

3676:
3677: -- Delete Standard Notes.
3678: delete from oke_k_standard_notes_tl
3679: where standard_notes_id in
3680: (select standard_notes_id from oke_k_standard_notes_b
3681: where k_line_id = p_contract_line_id);
3682:
3683: delete from oke_k_standard_notes_b where k_line_id = p_contract_line_id;
3684:

Line 3683: delete from oke_k_standard_notes_b where k_line_id = p_contract_line_id;

3679: where standard_notes_id in
3680: (select standard_notes_id from oke_k_standard_notes_b
3681: where k_line_id = p_contract_line_id);
3682:
3683: delete from oke_k_standard_notes_b where k_line_id = p_contract_line_id;
3684:
3685: -- Delete Print Forms
3686: delete from oke_k_print_forms where k_line_id = p_contract_line_id;
3687:

Line 6601: SELECT STANDARD_NOTES_ID FROM OKE_K_STANDARD_NOTES_B

6597:
6598: l_del_tbl_in oke_deliverable_pvt.del_tbl_type;
6599:
6600: CURSOR c4 IS
6601: SELECT STANDARD_NOTES_ID FROM OKE_K_STANDARD_NOTES_B
6602: WHERE DELIVERABLE_ID = p_deliverable_id;
6603:
6604:
6605: BEGIN

Line 6655: delete from oke_k_standard_notes_b

6651: where deliverable_id = p_deliverable_id;
6652:
6653: -- delete standard notes
6654: for cinfo in c4 loop
6655: delete from oke_k_standard_notes_b
6656: where standard_notes_id = cinfo.standard_notes_id;
6657:
6658: delete from oke_k_standard_notes_tl
6659: where standard_notes_id = cinfo.standard_notes_id;