APPS.JTF_UM_ENROLLMENT_CREDENTIALS dependencies on FND_RESPONSIBILITY_VL

Line 72: FROM FND_RESPONSIBILITY_VL

68: IS
69:
70: p_responsibility_id NUMBER;
71: CURSOR RESP_KEY IS SELECT RESPONSIBILITY_ID
72: FROM FND_RESPONSIBILITY_VL
73: WHERE RESPONSIBILITY_KEY = X_RESPONSIBILITY_KEY;
74: BEGIN
75:
76: OPEN RESP_KEY;

Line 104: FROM FND_RESPONSIBILITY_VL

100: IS
101:
102: p_responsibility_id NUMBER;
103: CURSOR RESP_KEY_ID IS SELECT RESPONSIBILITY_ID
104: FROM FND_RESPONSIBILITY_VL
105: WHERE RESPONSIBILITY_KEY = X_RESPONSIBILITY_KEY;
106: BEGIN
107:
108: OPEN RESP_KEY_ID;

Line 140: l_version FND_RESPONSIBILITY_VL.VERSION%TYPE;

136: p_subscription_app_id NUMBER;
137: p_principal_name VARCHAR2(255);
138: l_is_del_flag_set BOOLEAN;
139: l_role_id NUMBER;
140: l_version FND_RESPONSIBILITY_VL.VERSION%TYPE;
141: l_def_resp_id NUMBER;
142: l_def_app_id NUMBER;
143: l_def_resp_key FND_RESPONSIBILITY_VL.RESPONSIBILITY_KEY%TYPE;
144: l_def_resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;

Line 143: l_def_resp_key FND_RESPONSIBILITY_VL.RESPONSIBILITY_KEY%TYPE;

139: l_role_id NUMBER;
140: l_version FND_RESPONSIBILITY_VL.VERSION%TYPE;
141: l_def_resp_id NUMBER;
142: l_def_app_id NUMBER;
143: l_def_resp_key FND_RESPONSIBILITY_VL.RESPONSIBILITY_KEY%TYPE;
144: l_def_resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;
145:
146: CURSOR SUBSCRIPTION_RESP is select FR.RESPONSIBILITY_ID, FR.APPLICATION_ID, FR.VERSION FROM
147: JTF_UM_SUBSCRIPTION_RESP SB,

Line 144: l_def_resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;

140: l_version FND_RESPONSIBILITY_VL.VERSION%TYPE;
141: l_def_resp_id NUMBER;
142: l_def_app_id NUMBER;
143: l_def_resp_key FND_RESPONSIBILITY_VL.RESPONSIBILITY_KEY%TYPE;
144: l_def_resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;
145:
146: CURSOR SUBSCRIPTION_RESP is select FR.RESPONSIBILITY_ID, FR.APPLICATION_ID, FR.VERSION FROM
147: JTF_UM_SUBSCRIPTION_RESP SB,
148: FND_RESPONSIBILITY_VL FR

Line 148: FND_RESPONSIBILITY_VL FR

144: l_def_resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;
145:
146: CURSOR SUBSCRIPTION_RESP is select FR.RESPONSIBILITY_ID, FR.APPLICATION_ID, FR.VERSION FROM
147: JTF_UM_SUBSCRIPTION_RESP SB,
148: FND_RESPONSIBILITY_VL FR
149: WHERE SB.SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
150: AND SB.RESPONSIBILITY_KEY = FR.RESPONSIBILITY_KEY
151: AND SB.APPLICATION_ID = FR.APPLICATION_ID
152: AND (SB.EFFECTIVE_END_DATE IS NULL OR SB.EFFECTIVE_END_DATE > SYSDATE)