APPS.JUMF_LCT_PKG dependencies on JTF_UM_SUBSCRIPTION_RESP

Line 826: from JTF_UM_SUBSCRIPTION_RESP

822: return;
823: else
824: select count(*)
825: into v_active_record_count
826: from JTF_UM_SUBSCRIPTION_RESP
827: where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
828: and EFFECTIVE_END_DATE is NULL
829: and LAST_UPDATED_BY <> 1;
830:

Line 837: -- from JTF_UM_SUBSCRIPTION_RESP

833: end if;
834:
835: -- select LAST_UPDATED_BY
836: -- into v_db_owner_id
837: -- from JTF_UM_SUBSCRIPTION_RESP
838: -- where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
839: -- and RESPONSIBILITY_KEY = x_responsibility_key
840: -- and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
841:

Line 859: update JTF_UM_SUBSCRIPTION_RESP

855:
856: exception
857: when no_data_found then
858:
859: update JTF_UM_SUBSCRIPTION_RESP
860: set EFFECTIVE_END_DATE = SYSDATE
861: where EFFECTIVE_END_DATE is NULL
862: and SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'));
863: