APPS.PV_CONTACT_USER_BATCH_PUB dependencies on JTF_UM_SUBSCRIPTION_REG

Line 2009: select SUBSCRIPTION_REG_ID from jtf_um_subscription_reg where user_id=userid and subscription_id=subscriptionid;

2005: and c.usertype_key=user_type
2006: and a.usertype_id=c.usertype_id;
2007:
2008: CURSOR get_subscription(userid VARCHAR2, subscriptionid VARCHAR2) IS
2009: select SUBSCRIPTION_REG_ID from jtf_um_subscription_reg where user_id=userid and subscription_id=subscriptionid;
2010:
2011: cursor getLUDFromUserReg(l_user_reg_id VARCHAR2) is
2012: select to_char (last_update_date, 'mmddyyyyhh24miss')
2013: from jtf_um_usertype_reg