DBA Data[Home] [Help]

APPS.PER_CN_SHARED_INFO dependencies on PER_PERSON_ANALYSES

Line 187: from PER_PERSON_ANALYSES

183:
184: CURSOR get_anal_cri_id
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

Line 230: from PER_PERSON_ANALYSES

226:
227: CURSOR get_anal_cri_id
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