APPS.JTF_UM_PASSWORD_PVT dependencies on JTF_UM_SUBSCRIPTIONS_VL

Line 1313: from jtf_um_subscriptions_vl svl, jtf_um_subscription_reg reg

1309: document_type in out NOCOPY varchar2) is
1310:
1311: Cursor c_enrollment(p_subscr_reg_id in number) is
1312: select svl.subscription_name||decode(reg.status_code,'PENDING', '(*)') name
1313: from jtf_um_subscriptions_vl svl, jtf_um_subscription_reg reg
1314: where svl.subscription_id = reg.subscription_id
1315: and reg.subscription_reg_id = p_subscr_reg_id
1316: and status_code in ('APPROVED', 'PENDING')
1317: and NVL(reg.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE;