DBA Data[Home] [Help]

APPS.JTF_UM_SUBSCRIPTIONS_PKG dependencies on FND_USER

Line 802: FROM FND_USER FU, JTF_UM_SUBSCRIPTION_REG SUBREG

798: l_procedure_name CONSTANT varchar2(30) := 'update_grant_delegation_flag';
799: l_flag_value VARCHAR2(1) := 'N';
800:
801: CURSOR FIND_PRINCIPAL_NAME IS SELECT FU.USER_NAME, SUBREG.SUBSCRIPTION_ID
802: FROM FND_USER FU, JTF_UM_SUBSCRIPTION_REG SUBREG
803: WHERE FU.USER_ID = SUBREG.USER_ID
804: AND SUBREG.SUBSCRIPTION_REG_ID = p_subscription_reg_id;
805:
806: l_principal_name FND_USER.USER_NAME%TYPE;

Line 806: l_principal_name FND_USER.USER_NAME%TYPE;

802: FROM FND_USER FU, JTF_UM_SUBSCRIPTION_REG SUBREG
803: WHERE FU.USER_ID = SUBREG.USER_ID
804: AND SUBREG.SUBSCRIPTION_REG_ID = p_subscription_reg_id;
805:
806: l_principal_name FND_USER.USER_NAME%TYPE;
807: l_subscription_id NUMBER;
808: l_role_id NUMBER;
809:
810: begin

Line 978: FROM JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU

974:
975: l_procedure_name CONSTANT varchar2(30) := 'update_grant_delegation_flag';
976:
977: CURSOR FIND_REG_ID IS SELECT SUBSCRIPTION_REG_ID
978: FROM JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU
979: WHERE SUBSCRIPTION_ID = p_subscription_id
980: AND SUBREG.USER_ID = FU.USER_ID
981: AND FU.USER_NAME = p_user_name
982: AND NVL(SUBREG.EFFECTIVE_END_DATE, SYSDATE+1) > SYSDATE;

Line 1128: FROM JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU

1124: ) is
1125:
1126: l_procedure_name CONSTANT varchar2(30) := 'update_grant_delegation_flag';
1127: CURSOR FIND_REG_ID IS SELECT SUBSCRIPTION_REG_ID
1128: FROM JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU
1129: WHERE SUBSCRIPTION_ID = p_subscription_id
1130: AND SUBREG.USER_ID = FU.USER_ID
1131: AND FU.USER_ID = p_user_id
1132: AND NVL(SUBREG.EFFECTIVE_END_DATE, SYSDATE+1) > SYSDATE;