DBA Data[Home] [Help]

APPS.JTF_UM_UTIL_PVT dependencies on JTF_UM_SUBSCRIPTIONS_B

Line 1502: cursor find_subscription_id is select subscription_id from jtf_um_subscriptions_b where

1498:
1499: function VALIDATE_SUBSCRIPTION_ID(p_subscription_id number) return boolean is
1500:
1501: l_procedure_name CONSTANT varchar2(30) := 'VALIDATE_SUBSCRIPTION_ID';
1502: cursor find_subscription_id is select subscription_id from jtf_um_subscriptions_b where
1503: subscription_id = p_subscription_id and nvl(effective_end_date, sysdate+1) > sysdate;
1504:
1505: l_dummy_value number;
1506: