APPS.PO_APPROVAL_LIST_HISTORY_SV dependencies on WF_ROLES

Line 183: l_more_origsys wf_roles.orig_system%TYPE;

179: /* begin bug 3090563
180: * notification enhancement to support more info requested
181: */
182: l_more_info_role wf_notifications.more_info_role%TYPE;
183: l_more_origsys wf_roles.orig_system%TYPE;
184: l_more_origsysid wf_roles.orig_system_id%TYPE := null;
185: /* end bug 3090563 */
186: l_appr_and_fwd_flag boolean := FALSE;-- Flag to check if we have 'APPROVE_AND_FORWARD' action
187: /* bug 1817306 new cursor c_responderid is defined to replace c_responder */

Line 184: l_more_origsysid wf_roles.orig_system_id%TYPE := null;

180: * notification enhancement to support more info requested
181: */
182: l_more_info_role wf_notifications.more_info_role%TYPE;
183: l_more_origsys wf_roles.orig_system%TYPE;
184: l_more_origsysid wf_roles.orig_system_id%TYPE := null;
185: /* end bug 3090563 */
186: l_appr_and_fwd_flag boolean := FALSE;-- Flag to check if we have 'APPROVE_AND_FORWARD' action
187: /* bug 1817306 new cursor c_responderid is defined to replace c_responder */
188: CURSOR c_responderid(p_responder VARCHAR2) IS

Line 277: FROM WF_ROLES WFU

273: CLOSE c_responderid;
274:
275: SELECT WFU.ORIG_SYSTEM_ID
276: INTO l_original_recipient_id
277: FROM WF_ROLES WFU
278: WHERE WFU.NAME = l_original_recipient
279: AND WFU.ORIG_SYSTEM NOT IN ('POS', 'ENG_LIST', 'CUST_CONT');
280:
281: END IF;