APPS.JTF_UM_PASSWORD_PVT dependencies on JTF_UM_SUBSCRIPTIONS_VL

Line 1364: from jtf_um_subscriptions_vl svl, jtf_um_subscription_reg reg

1360: document_type in out NOCOPY varchar2) is
1361:
1362: Cursor c_enrollment(p_subscr_reg_id in number) is
1363: select svl.subscription_name||decode(reg.status_code,'PENDING', '(*)') name
1364: from jtf_um_subscriptions_vl svl, jtf_um_subscription_reg reg
1365: where svl.subscription_id = reg.subscription_id
1366: and reg.subscription_reg_id = p_subscr_reg_id
1367: and status_code in ('APPROVED', 'PENDING')
1368: and NVL(reg.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE;