APPS.OKE_STANDARD_NOTES_PUB dependencies on OKE_K_STANDARD_NOTES_VL

Line 955: FROM OKE_K_STANDARD_NOTES_VL b

951: b.DESCRIPTION ,
952: b.NAME ,
953: b.TEXT ,
954: b.default_flag
955: FROM OKE_K_STANDARD_NOTES_VL b
956: WHERE b.DELIVERABLE_ID = p_id
957: AND b.LINE_ID IS NULL;
958:
959: CURSOR note_cle_csr (p_id IN NUMBER) IS

Line 992: FROM OKE_K_STANDARD_NOTES_VL B

988: b.DESCRIPTION ,
989: b.NAME ,
990: b.TEXT ,
991: b.default_flag
992: FROM OKE_K_STANDARD_NOTES_VL B
993: WHERE b.LINE_ID = p_id
994: AND b.DELIVERABLE_ID IS NULL;
995:
996: CURSOR note_hdr_csr (p_id IN NUMBER) IS

Line 1029: FROM OKE_K_STANDARD_NOTES_VL B

1025: b.DESCRIPTION ,
1026: b.NAME ,
1027: b.TEXT ,
1028: b.default_flag
1029: FROM OKE_K_STANDARD_NOTES_VL B
1030: WHERE b.HEADER_ID = p_id
1031: AND b.DELIVERABLE_ID IS NULL AND b.LINE_ID IS NULL;
1032:
1033: BEGIN