DBA Data[Home] [Help]

APPS.JTF_UM_WF_APPROVAL dependencies on JTF_UM_USERTYPE_RESP

Line 650: from fnd_responsibility_vl rvl, jtf_um_usertype_resp utr

646: and nvl (EFFECTIVE_END_DATE, sysdate + 1) > sysdate;
647:
648: cursor getUTRespApplID is
649: select rvl.responsibility_id, rvl.application_id
650: from fnd_responsibility_vl rvl, jtf_um_usertype_resp utr
651: where utr.usertype_id = requestId
652: and utr.responsibility_key = rvl.responsibility_key
653: and nvl (rvl.end_date, sysdate + 1) > sysdate
654: and nvl (utr.effective_end_date, sysdate + 1) > sysdate