APPS.JTF_UM_WF_DELEGATION_PVT dependencies on JTF_UM_SUBSCRIPTION_REG

Line 811: FROM JTF_UM_SUBSCRIPTION_REG

807:
808: l_procedure_name CONSTANT varchar2(30) := 'get_checkbox_status';
809:
810: CURSOR FIND_DELEGATION_FLAG IS SELECT GRANT_DELEGATION_FLAG,SUBSCRIPTION_ID
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

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:

Line 820: l_grant_delegation_flag JTF_UM_SUBSCRIPTION_REG.GRANT_DELEGATION_FLAG%TYPE;

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:
820: l_grant_delegation_flag JTF_UM_SUBSCRIPTION_REG.GRANT_DELEGATION_FLAG%TYPE;
821: l_subscription_id JTF_UM_SUBSCRIPTION_REG.SUBSCRIPTION_ID%TYPE;
822: l_delegation_role_id JTF_UM_SUBSCRIPTIONS_B.AUTH_DELEGATION_ROLE_ID%TYPE;
823: l_flag_boolean boolean := false;
824: l_usertype_id number;

Line 821: l_subscription_id JTF_UM_SUBSCRIPTION_REG.SUBSCRIPTION_ID%TYPE;

817: AND SUBREG.SUBSCRIPTION_REG_ID = p_reg_id
818: and nvl(UTREG.effective_end_date,sysdate+1) > sysdate;
819:
820: l_grant_delegation_flag JTF_UM_SUBSCRIPTION_REG.GRANT_DELEGATION_FLAG%TYPE;
821: l_subscription_id JTF_UM_SUBSCRIPTION_REG.SUBSCRIPTION_ID%TYPE;
822: l_delegation_role_id JTF_UM_SUBSCRIPTIONS_B.AUTH_DELEGATION_ROLE_ID%TYPE;
823: l_flag_boolean boolean := false;
824: l_usertype_id number;
825: