DBA Data[Home] [Help]

APPS.PAY_RESTRICT_VAL_PKG dependencies on PER_SPECIAL_INFO_TYPES

Line 129: PER_SPECIAL_INFO_TYPES S

125:
126: CURSOR C_SPECIAL_INFO IS
127: SELECT F.ID_FLEX_STRUCTURE_NAME
128: FROM FND_ID_FLEX_STRUCTURES_VL F,
129: PER_SPECIAL_INFO_TYPES S
130: WHERE S.SPECIAL_INFORMATION_TYPE_ID = P_VALUE
131: AND S.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
132: AND F.ID_FLEX_NUM = S.ID_FLEX_NUM
133: AND F.ID_FLEX_CODE = 'PEA';

Line 366: , PER_SPECIAL_INFO_TYPES S

362: --
363: CURSOR C_SPECIAL_INFO IS
364: SELECT F.ID_FLEX_STRUCTURE_NAME
365: FROM FND_ID_FLEX_STRUCTURES_VL F
366: , PER_SPECIAL_INFO_TYPES S
367: WHERE S.SPECIAL_INFORMATION_TYPE_ID = P_VALUE
368: AND S.BUSINESS_GROUP_ID IS NULL
369: AND F.ID_FLEX_NUM = S.ID_FLEX_NUM
370: AND F.ID_FLEX_CODE = 'PEA';

Line 451: , PER_SPECIAL_INFO_TYPES S

447: --
448: CURSOR C_SPECIAL_INFO IS
449: SELECT S.SPECIAL_INFORMATION_TYPE_ID
450: FROM FND_ID_FLEX_STRUCTURES_VL F
451: , PER_SPECIAL_INFO_TYPES S
452: WHERE F.ID_FLEX_STRUCTURE_NAME = P_VALUE
453: AND F.ID_FLEX_CODE = 'PEA'
454: AND F.ID_FLEX_NUM = S.ID_FLEX_NUM
455: AND S.BUSINESS_GROUP_ID IS NULL;