DBA Data[Home] [Help]

APPS.PER_RESTR_VALUES_PKG dependencies on FND_APPLICATION

Line 23: from fnd_application

19: l_appl_id number;
20: l_cr_id number;
21: CURSOR C_APPL IS
22: select application_id
23: from fnd_application
24: where application_short_name = upper(P_APPLICATION_SHORT_NAME);
25: cursor C_CR_ID is
26: select customized_restriction_id
27: from PAY_CUSTOMIZED_RESTRICTIONS pcr

Line 78: from fnd_application

74: l_cr_id number;
75: l_appl_id number;
76: cursor C_APPL is
77: select application_id
78: from fnd_application
79: where application_short_name = upper(X_APPLICATION_SHORT_NAME);
80: cursor C_CR_ID is
81: select customized_restriction_id
82: from PAY_CUSTOMIZED_RESTRICTIONS pcr

Line 147: from fnd_application

143: l_appl_id number;
144: l_cr_id number;
145: cursor C_APPL is
146: select application_id
147: from fnd_application
148: where application_short_name = upper(X_APPLICATION_SHORT_NAME);
149: cursor C_CR_ID is
150: select customized_restriction_id
151: from PAY_CUSTOMIZED_RESTRICTIONS pcr

Line 212: from fnd_application

208: l_appl_id number;
209: l_cr_id number;
210: cursor C_APPL is
211: select application_id
212: from fnd_application
213: where application_short_name = X_APPLICATION_SHORT_NAME;
214: cursor C_CR_ID is
215: select customized_restriction_id
216: from PAY_CUSTOMIZED_RESTRICTIONS pcr

Line 258: from fnd_application

254: l_appl_id number;
255: l_cr_id number;
256: cursor C_APPL is
257: select application_id
258: from fnd_application
259: where application_short_name = X_APPLICATION_SHORT_NAME;
260: cursor C_CR_ID is
261: select customized_restriction_id
262: from PAY_CUSTOMIZED_RESTRICTIONS pcr