DBA Data[Home] [Help]

APPS.JTF_UM_WF_APPROVAL dependencies on JTF_UM_SUBSCRIPTION_RESP

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