DBA Data[Home] [Help]

APPS.JTF_UM_WF_DELEGATION_PVT dependencies on JTF_UM_USERTYPE_REG

Line 815: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_SUBSCRIPTION_REG SUBREG

811: FROM JTF_UM_SUBSCRIPTION_REG
812: WHERE SUBSCRIPTION_REG_ID = p_reg_id;
813:
814: CURSOR FIND_USERTYPE_ID IS SELECT UTREG.USERTYPE_ID
815: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_SUBSCRIPTION_REG SUBREG
816: WHERE SUBREG.USER_ID = UTREG.USER_ID
817: AND SUBREG.SUBSCRIPTION_REG_ID = p_reg_id
818: and nvl(UTREG.effective_end_date,sysdate+1) > sysdate;
819: