APPS.PER_CUSTOMIZED_RESTR_PKG dependencies on FND_APPLICATION

Line 41: from fnd_application

37: L_DUMMY1 number;
38: l_appl_id number;
39: CURSOR C_APPL IS
40: select application_id
41: from fnd_application
42: where application_short_name = upper(P_APPLICATION_SHORT_NAME);
43: CURSOR C1 (c1_p_appl_id number) IS
44: select 1
45: from PAY_CUSTOMIZED_RESTRICTIONS pcr

Line 385: from fnd_application

381: l_appl_id PAY_CUSTOMIZED_RESTRICTIONS.application_id%TYPE;
382:
383: CURSOR C_APPL IS
384: select application_id
385: from fnd_application
386: where application_short_name = upper(X_APPLICATION_SHORT_NAME);
387:
388: CURSOR C1 IS
389: select customized_restriction_id , comments , business_group_id

Line 482: from fnd_application

478: l_cust_rest_id PAY_CUSTOMIZED_RESTRICTIONS.customized_restriction_id%TYPE ;
479:
480: CURSOR C_APPL IS
481: select application_id
482: from fnd_application
483: where application_short_name = upper(X_APPLICATION_SHORT_NAME);
484:
485: CURSOR C1 IS
486: select customized_restriction_id