APPS.PER_CN_SHARED_INFO dependencies on FND_ID_FLEX_STRUCTURES_VL

Line 192: from FND_ID_FLEX_STRUCTURES_VL

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
194: ID_FLEX_STRUCTURE_CODE = 'PER_JOB_CLASS_INFO_CN'
195: )
196: order by date_from desc;

Line 235: from FND_ID_FLEX_STRUCTURES_VL

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
237: ID_FLEX_STRUCTURE_CODE = 'PER_TECH_PROF_POST_CN'
238: )
239: order by date_from desc;