APPS.AR_CONFIRMATION dependencies on AR_CONFIRMATION_ACTIONS

Line 14: select handler_name, handler_type from ar_confirmation_actions

10: select DISTINCT 'FND_RESP222:'||to_char(responsibility_id) role_name
11: from fnd_responsibility_tl
12: where application_id = 222;
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);