APPS.JA_CN_PS_HRMS_EXPORT_PKG dependencies on FND_ID_FLEX_STRUCTURES_VL

Line 346: FROM fnd_id_flex_structures_vl

342: WHERE person_id = pn_person_id
343: AND business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
344: AND pd_date BETWEEN date_from AND nvl(date_to,to_date('31-12-4712','dd-mm-yyyy'))
345: AND id_flex_num = (SELECT id_flex_num
346: FROM fnd_id_flex_structures_vl
347: WHERE id_flex_code='PEA'
348: AND id_flex_structure_code = 'PER_JOB_CLASS_INFO_CN'
349: )
350: ORDER BY date_from DESC;

Line 419: FROM fnd_id_flex_structures_vl

415: WHERE person_id = pn_person_id
416: AND business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
417: AND pd_date BETWEEN date_from AND nvl(date_to,to_date('31-12-4712','dd-mm-yyyy'))
418: AND id_flex_num = (SELECT id_flex_num
419: FROM fnd_id_flex_structures_vl
420: WHERE id_flex_code='PEA'
421: AND id_flex_structure_code = 'PER_TECH_PROF_POST_CN'
422: )
423: ORDER BY date_from DESC;