APPS.AR_CONFIRMATION dependencies on ECX_DOCLOGS

Line 17: select msgid from ecx_doclogs where internal_control_number = p_int_ctr_num;

13: cursor action is
14: select handler_name, handler_type from ar_confirmation_actions
15: where status = p_status and (reason_code = p_reason_code or p_reason_code is null);
16: cursor msgid is
17: select msgid from ecx_doclogs where internal_control_number = p_int_ctr_num;
18: l_handler_name varchar2(70);
19: l_handler_type varchar2(30);
20: l_sqlerrm varchar2(2000);
21: l_subject varchar2(200);