DBA Data[Home] [Help]

APPS.JTF_UM_WF_APPROVAL dependencies on FND_RESPONSIBILITY_VL

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

Line 659: from fnd_responsibility_vl rvl, jtf_um_subscription_resp utr

655: and rvl.version in ('W','4');
656:
657: cursor getEnrollRespApplID is
658: select rvl.responsibility_id, rvl.application_id
659: from fnd_responsibility_vl rvl, jtf_um_subscription_resp utr
660: where utr.subscription_id = requestId
661: and utr.responsibility_key = rvl.responsibility_key
662: and nvl (rvl.end_date, sysdate + 1) > sysdate
663: and nvl (utr.effective_end_date, sysdate + 1) > sysdate