DBA Data[Home] [Help]

APPS.ENG_CHANGE_LINE_UTIL dependencies on ENG_ENGINEERING_CHANGES

Line 72: SELECT change_id FROM eng_engineering_changes

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;

Line 366: SELECT change_id FROM eng_engineering_changes

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