185: IS
186: select ANALYSIS_CRITERIA_ID
187: from PER_PERSON_ANALYSES
188: where person_id = p_person_id
189: and business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
190: and p_date between date_from and nvl(date_to,to_date('31-12-4712','dd-mm-yyyy'))
191: and ID_FLEX_NUM = (select ID_FLEX_NUM
192: from FND_ID_FLEX_STRUCTURES_VL
193: where ID_FLEX_CODE='PEA' and
228: IS
229: select ANALYSIS_CRITERIA_ID
230: from PER_PERSON_ANALYSES
231: where person_id = p_person_id
232: and business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
233: and p_date between date_from and nvl(date_to,to_date('31-12-4712','dd-mm-yyyy'))
234: and ID_FLEX_NUM = (select ID_FLEX_NUM
235: from FND_ID_FLEX_STRUCTURES_VL
236: where ID_FLEX_CODE='PEA' and