APPS.PAY_CUST_RESTRICT_PKG dependencies on PAY_CUSTOMIZED_RESTRICTIONS

Line 14: FROM PAY_CUSTOMIZED_RESTRICTIONS PCR

10: L_DUMMY VARCHAR2(1);
11: CURSOR C_C1 IS
12: SELECT 1
13:
14: FROM PAY_CUSTOMIZED_RESTRICTIONS PCR
15: WHERE UPPER(PCR.NAME) = UPPER(P_NAME)
16:
17: AND nvl(PCR.business_group_id, nvl(P_BUSINESS_GROUP_ID, -9999) )
18: = nvl(P_BUSINESS_GROUP_ID, -9999)

Line 25: SELECT PAY_CUSTOMIZED_RESTRICTIONS_S.NEXTVAL

21: AND (PCR.ROWID <> P_ROWID OR P_ROWID IS NULL);
22:
23:
24: CURSOR C_NEXTVAL IS
25: SELECT PAY_CUSTOMIZED_RESTRICTIONS_S.NEXTVAL
26: FROM SYS.DUAL;
27: BEGIN
28: OPEN C_C1;
29: FETCH C_C1 INTO L_DUMMY;