APPS.ITA_NOTIFICATION_PKG dependencies on WF_ROLES

Line 419: cursor GET_WF_ROLES(p_orig_system_id NUMBER) is

415: m_role_name VARCHAR2(100);
416: m_role_display_name VARCHAR2(240);
417:
418:
419: cursor GET_WF_ROLES(p_orig_system_id NUMBER) is
420: select NAME, substrb(DISPLAY_NAME, 1, 360) display_name
421: from WF_ROLES
422: where
423: ORIG_SYSTEM = 'PER' and

Line 421: from WF_ROLES

417:
418:
419: cursor GET_WF_ROLES(p_orig_system_id NUMBER) is
420: select NAME, substrb(DISPLAY_NAME, 1, 360) display_name
421: from WF_ROLES
422: where
423: ORIG_SYSTEM = 'PER' and
424: ORIG_SYSTEM_ID = p_orig_system_id
425: order by STATUS, START_DATE;

Line 468: for role in GET_WF_ROLES(m_process_owner_emp_id) loop

464: p_orig_system_id => m_process_owner_emp_id,
465: p_name => m_role_name,
466: p_display_name => m_role_display_name);
467: */
468: for role in GET_WF_ROLES(m_process_owner_emp_id) loop
469: m_role_name := role.NAME;
470: m_role_display_name := role.DISPLAY_NAME;
471:
472: if m_role_name is null then