68: Cursor c_csr( p_change_notice VARCHAR2
69: , p_organization_id NUMBER
70: )
71: IS
72: SELECT change_id FROM eng_engineering_changes
73: WHERE change_notice = p_change_notice and organization_id = p_organization_id;
74:
75: cl_rec cl_csr%ROWTYPE ;
76: l_change_id NUMBER;
362: Cursor c_csr( p_change_notice VARCHAR2
363: , p_organization_id NUMBER
364: )
365: IS
366: SELECT change_id FROM eng_engineering_changes
367: WHERE change_notice = p_change_notice and organization_id = p_organization_id;
368:
369: l_change_id NUMBER;
370: BEGIN