DBA Data[Home] [Help]

APPS.PAY_RESTRICT_VAL_PKG dependencies on FND_ID_FLEX_STRUCTURES_VL

Line 128: FROM FND_ID_FLEX_STRUCTURES_VL F,

124: AND HR.LOOKUP_TYPE ='PER_FUNCTION';
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

Line 365: FROM FND_ID_FLEX_STRUCTURES_VL F

361: AND REPS.QP_REPORT_ID = P_VALUE;
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

Line 450: FROM FND_ID_FLEX_STRUCTURES_VL F

446: AND REPS.LEGISLATION_CODE = P_LEG_CODE));
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