eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_WF_K_APPROVE dependencies on WF_USERS

Line 552: from wf_user_roles r, wf_users u

548: /* the cursor changed because of bug#2316572 -- INCORRECT APPROVER NAME FOR FORWARDED CONTRACT APPROVAL
549: cursor Actual_Performer_csr is
550: select --+ORDERED
551: u.name, u.display_name
552: from wf_user_roles r, wf_users u
553: where r.role_name=l_name
554: and r.USER_ORIG_SYSTEM=u.ORIG_SYSTEM
555: and r.USER_ORIG_SYSTEM_ID=u.ORIG_SYSTEM_ID
556: and

Line 569: wf_users u

565: /* cursor Actual_Performer_csr is
566: select --+ORDERED
567: u.name, u.display_name
568: from
569: wf_users u
570: where
571: (
572: (l_context not like 'email:%' and u.NAME=l_context)
573: or

Line 580: from wf_users u

576: */
577: -- Broken the above cursor into two due to bug 4865186 to avoid FTS
578: CURSOR csr_actual_performer_1(p_context IN VARCHAR2) IS
579: select u.name, u.display_name
580: from wf_users u
581: where UPPER(u.EMAIL_ADDRESS)=UPPER(substr(p_context,7));
582:
583: CURSOR csr_actual_performer_2(p_context IN VARCHAR2) IS
584: select u.name, u.display_name

Line 585: from wf_users u

581: where UPPER(u.EMAIL_ADDRESS)=UPPER(substr(p_context,7));
582:
583: CURSOR csr_actual_performer_2(p_context IN VARCHAR2) IS
584: select u.name, u.display_name
585: from wf_users u
586: where u.NAME=p_context;
587:
588: begin
589: --

Line 668: wf_users u

664: cursor Actual_Performer_csr is
665: select --+ORDERED
666: u.name, u.display_name
667: from
668: wf_users u
669: where
670: (
671: (l_context not like 'email:%' and u.NAME=l_context)
672: or

Line 679: from wf_users u

675: */
676: -- Broken the above cursor into two due to bug 4865186 to avoid FTS
677: CURSOR csr_actual_performer_1(p_context IN VARCHAR2) IS
678: select u.name, u.display_name
679: from wf_users u
680: where UPPER(u.EMAIL_ADDRESS)=UPPER(substr(p_context,7));
681:
682: CURSOR csr_actual_performer_2(p_context IN VARCHAR2) IS
683: select u.name, u.display_name

Line 684: from wf_users u

680: where UPPER(u.EMAIL_ADDRESS)=UPPER(substr(p_context,7));
681:
682: CURSOR csr_actual_performer_2(p_context IN VARCHAR2) IS
683: select u.name, u.display_name
684: from wf_users u
685: where u.NAME=p_context;
686:
687: /*Added for bug 8558419*/
688: CURSOR csr_vacation_rule(p_name IN VARCHAR2) IS