DBA Data[Home] [Help]

APPS.JTF_UM_RESP_INFO_PVT dependencies on JTF_UM_SUBSCRIPTIONS_VL

Line 101: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_SUBSCRIPTION_RESP SUBRESP, JTF_UM_SUBSCRIPTION_REG SUBREG

97:
98: UNION ALL
99:
100: SELECT 'ENROLLMENT' SOURCE_TYPE, SUB.SUBSCRIPTION_NAME SOURCE_NAME
101: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_SUBSCRIPTION_RESP SUBRESP, JTF_UM_SUBSCRIPTION_REG SUBREG
102: WHERE SUB.SUBSCRIPTION_ID = SUBRESP.SUBSCRIPTION_ID
103: AND SUB.SUBSCRIPTION_ID = SUBREG.SUBSCRIPTION_ID
104: AND SUBREG.USER_ID = p_user_id
105: AND SUBRESP.RESPONSIBILITY_KEY = l_resp_key