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:
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: