eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRI_OPL_EVENT_CAPTURE dependencies on PER_PERSON_TYPE_USAGES_F

Line 432: FROM per_person_type_usages_f ptu,

428: IS
429: --
430: CURSOR c_ptu IS
431: SELECT 1
432: FROM per_person_type_usages_f ptu,
433: per_person_types ppt
434: WHERE 1=1
435: AND ptu.person_type_usage_id = p_person_type_usage_id
436: AND p_effective_date BETWEEN ptu.effective_start_date and ptu.effective_end_date

Line 2429: g_person_type_table_id := get_dated_table_id('PER_PERSON_TYPE_USAGES_F');

2425: g_prd_of_srvc_table_id := get_dated_table_id('PER_PERIODS_OF_SERVICE');
2426: g_appraisal_table_id := get_dated_table_id('PER_APPRAISALS');
2427: g_perf_review_table_id := get_dated_table_id('PER_PERFORMANCE_REVIEWS');
2428: g_asg_table_id := get_dated_table_id('PER_ALL_ASSIGNMENTS_F');
2429: g_person_type_table_id := get_dated_table_id('PER_PERSON_TYPE_USAGES_F');
2430: --
2431: g_absence_attendance_table_id := get_dated_table_id('PER_ABSENCE_ATTENDANCES');
2432: --
2433: capture_events

Line 2840: g_person_type_table_id := get_dated_table_id('PER_PERSON_TYPE_USAGES_F');

2836: g_prd_of_srvc_table_id := get_dated_table_id('PER_PERIODS_OF_SERVICE');
2837: g_appraisal_table_id := get_dated_table_id('PER_APPRAISALS');
2838: g_perf_review_table_id := get_dated_table_id('PER_PERFORMANCE_REVIEWS');
2839: g_asg_table_id := get_dated_table_id('PER_ALL_ASSIGNMENTS_F');
2840: g_person_type_table_id := get_dated_table_id('PER_PERSON_TYPE_USAGES_F');
2841: --
2842: -- 3906029 The event date to be populated in the supervisor hierarchy
2843: -- events queue should not be lesser than the last full refresh date
2844: -- or the minimum date in the hierarchy

Line 2865: attribute13 = g_person_type_table_id -- Dated table id of PER_PERSON_TYPE_USAGES_F

2861: attribute9 = g_prd_of_srvc_table_id,
2862: attribute10 = g_appraisal_table_id,
2863: attribute11 = g_perf_review_table_id,
2864: attribute12 = g_asg_table_id,
2865: attribute13 = g_person_type_table_id -- Dated table id of PER_PERSON_TYPE_USAGES_F
2866: WHERE mthd_action_id = p_mthd_action_id;
2867: --
2868: dbg('Completed storing the parameter values for use by the slave processes ...');
2869: --