DBA Data[Home] [Help]

APPS.PAY_RESTRICT_VAL_PKG dependencies on PAY_RESTRICTION_PARAMETERS

Line 23: FROM PAY_RESTRICTION_PARAMETERS PRP

19: AND (PRV.ROWID <> P_ROWID
20: OR P_ROWID IS NULL);
21: CURSOR C_MULTIPLE_RES IS
22: SELECT 1
23: FROM PAY_RESTRICTION_PARAMETERS PRP
24: WHERE PRP.APPLICATION_ID = P_APPLICATION_ID
25: AND PRP.FORM_NAME = P_FORM_NAME
26: AND PRP.RESTRICTION_CODE = P_RESTRICTION_CODE
27: AND PRP.MULTIPLE_RESTRICTIONS_FLAG = 'N'