DBA Data[Home] [Help]

APPS.PER_PEOPLE_INFO_TYPES_SEC_PKG dependencies on FND_APPLICATION

Line 20: from fnd_application

16: l_appl_id number;
17: l_resp_id number;
18: CURSOR C_APPL IS
19: select application_id
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

Line 71: from fnd_application

67: l_appl_id number;
68: l_resp_id number;
69: cursor C_APPL is
70: select application_id
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

Line 143: from fnd_application

139: l_appl_id number;
140: l_resp_id number;
141: cursor C_APPL is
142: select application_id
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

Line 203: from fnd_application

199: l_appl_id number;
200: l_resp_id number;
201: cursor C_APPL is
202: select application_id
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

Line 243: from fnd_application

239: l_appl_id number;
240: l_resp_id number;
241: cursor C_APPL is
242: select application_id
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