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;