APPS.PER_PEOPLE_INFO_TYPES_SEC_PKG dependencies on FND_RESPONSIBILITY_VL

Line 24: from fnd_responsibility_vl

20: from fnd_application
21: where application_short_name = upper(P_APPLICATION_SHORT_NAME);
22: CURSOR C_RESP IS
23: select responsibility_id
24: from fnd_responsibility_vl
25: where responsibility_key = P_RESPONSIBILITY_KEY;
26: CURSOR C1 (c1_p_appl_id number, c1_p_resp_id number) IS
27: select 1
28: from PER_INFO_TYPE_SECURITY t

Line 75: from fnd_responsibility_vl

71: from fnd_application
72: where application_short_name = upper(X_APPLICATION_SHORT_NAME);
73: cursor C_RESP is
74: select responsibility_id
75: from fnd_responsibility_vl
76: where responsibility_key = X_RESPONSIBILITY_KEY;
77: cursor C_SEC_ID is
78: select per_info_type_security_s.nextval
79: from sys.dual;

Line 147: from fnd_responsibility_vl

143: from fnd_application
144: where application_short_name = upper(X_APPLICATION_SHORT_NAME);
145: cursor C_RESP is
146: select responsibility_id
147: from fnd_responsibility_vl
148: where responsibility_key = X_RESPONSIBILITY_KEY;
149: cursor c (c_p_appl_id number, c_p_resp_id number) is select
150: INFORMATION_TYPE,
151: OBJECT_VERSION_NUMBER

Line 207: from fnd_responsibility_vl

203: from fnd_application
204: where application_short_name = X_APPLICATION_SHORT_NAME;
205: cursor C_RESP is
206: select responsibility_id
207: from fnd_responsibility_vl
208: where responsibility_key = X_RESPONSIBILITY_KEY;
209: begin
210: open C_APPL;
211: fetch C_APPL into l_appl_id;

Line 247: from fnd_responsibility_vl

243: from fnd_application
244: where application_short_name = X_APPLICATION_SHORT_NAME;
245: cursor C_RESP is
246: select responsibility_id
247: from fnd_responsibility_vl
248: where responsibility_key = X_RESPONSIBILITY_KEY;
249: begin
250: open C_APPL;
251: fetch C_APPL into l_appl_id;