APPS.JA_CN_PS_HRMS_EXPORT_PKG dependencies on PER_PERSON_ANALYSES

Line 341: per_person_analyses

337: IS
338: SELECT
339: analysis_criteria_id
340: FROM
341: per_person_analyses
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

Line 414: per_person_analyses

410: IS
411: SELECT
412: analysis_criteria_id
413: FROM
414: per_person_analyses
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