DBA Data[Home] [Help]

APPS.JTF_UM_WF_APPROVAL dependencies on JTF_UM_SUBSCRIPTIONS_VL

Line 40: from jtf_um_subscriptions_vl

36: where usertype_id = x_usertype_id;
37:
38: cursor getSubscriptionName(x_subscription_id in number) is
39: select SUBSCRIPTION_NAME
40: from jtf_um_subscriptions_vl
41: where subscription_id = x_subscription_id;
42:
43: begin
44:

Line 77: from jtf_um_subscriptions_vl

73: where usertype_id = x_usertype_id;
74:
75: cursor getSubscriptionApplID (x_subscription_id in number) is
76: select application_id
77: from jtf_um_subscriptions_vl
78: where subscription_id = x_subscription_id;
79:
80: begin
81: