APPS.PER_RESTR_VALUES_PKG dependencies on PAY_CUSTOMIZED_RESTRICTIONS

Line 27: from PAY_CUSTOMIZED_RESTRICTIONS pcr

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
28: where
29: pcr.application_id = l_appl_id
30: and pcr.form_name = P_FORM_NAME
31: and pcr.name = P_NAME

Line 82: from PAY_CUSTOMIZED_RESTRICTIONS pcr

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
83: where
84: pcr.application_id = l_appl_id
85: and pcr.form_name = X_FORM_NAME
86: and pcr.name = X_NAME

Line 151: from PAY_CUSTOMIZED_RESTRICTIONS pcr

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
152: where
153: pcr.application_id = l_appl_id
154: and pcr.form_name = X_FORM_NAME
155: and pcr.name = X_NAME

Line 216: from PAY_CUSTOMIZED_RESTRICTIONS pcr

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
217: where
218: pcr.application_id = l_appl_id
219: and pcr.form_name = X_FORM_NAME
220: and pcr.name = X_NAME

Line 262: from PAY_CUSTOMIZED_RESTRICTIONS pcr

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
263: where
264: pcr.application_id = l_appl_id
265: and pcr.form_name = X_FORM_NAME
266: and pcr.name = X_NAME