APPS.PAY_RESTRICT_VAL_PKG dependencies on PAY_RESTRICTION_VALUES

Line 15: FROM PAY_RESTRICTION_VALUES PRV

11: L_DUMMY1 number;
12: L_DUMMY2 number;
13: CURSOR C_UNIQUENESS IS
14: SELECT 1
15: FROM PAY_RESTRICTION_VALUES PRV
16: WHERE PRV.VALUE = P_VALUE
17: AND PRV.CUSTOMIZED_RESTRICTION_ID = P_CUSTOMIZED_RESTRICTION_ID
18: AND PRV.RESTRICTION_CODE = P_RESTRICTION_CODE
19: AND (PRV.ROWID <> P_ROWID

Line 30: FROM PAY_RESTRICTION_VALUES PRV

26: AND PRP.RESTRICTION_CODE = P_RESTRICTION_CODE
27: AND PRP.MULTIPLE_RESTRICTIONS_FLAG = 'N'
28: AND EXISTS
29: (SELECT 1
30: FROM PAY_RESTRICTION_VALUES PRV
31: WHERE PRV.CUSTOMIZED_RESTRICTION_ID = P_CUSTOMIZED_RESTRICTION_ID2
32: AND PRV.RESTRICTION_CODE = PRP.RESTRICTION_CODE
33: AND (PRV.ROWID <> P_ROWID
34: OR P_ROWID IS NULL));