[Home] [Help]
431: IS
432: --
433: CURSOR c_ptu IS
434: SELECT 1
435: FROM per_person_type_usages_f ptu,
436: per_person_types ppt
437: WHERE 1=1
438: AND ptu.person_type_usage_id = p_person_type_usage_id
439: AND p_effective_date BETWEEN ptu.effective_start_date and ptu.effective_end_date
2428: g_prd_of_srvc_table_id := get_dated_table_id('PER_PERIODS_OF_SERVICE');
2429: g_appraisal_table_id := get_dated_table_id('PER_APPRAISALS');
2430: g_perf_review_table_id := get_dated_table_id('PER_PERFORMANCE_REVIEWS');
2431: g_asg_table_id := get_dated_table_id('PER_ALL_ASSIGNMENTS_F');
2432: g_person_type_table_id := get_dated_table_id('PER_PERSON_TYPE_USAGES_F');
2433: --
2434: g_absence_attendance_table_id := get_dated_table_id('PER_ABSENCE_ATTENDANCES');
2435: --
2436: capture_events
2839: g_prd_of_srvc_table_id := get_dated_table_id('PER_PERIODS_OF_SERVICE');
2840: g_appraisal_table_id := get_dated_table_id('PER_APPRAISALS');
2841: g_perf_review_table_id := get_dated_table_id('PER_PERFORMANCE_REVIEWS');
2842: g_asg_table_id := get_dated_table_id('PER_ALL_ASSIGNMENTS_F');
2843: g_person_type_table_id := get_dated_table_id('PER_PERSON_TYPE_USAGES_F');
2844: --
2845: -- 3906029 The event date to be populated in the supervisor hierarchy
2846: -- events queue should not be lesser than the last full refresh date
2847: -- or the minimum date in the hierarchy
2864: attribute9 = g_prd_of_srvc_table_id,
2865: attribute10 = g_appraisal_table_id,
2866: attribute11 = g_perf_review_table_id,
2867: attribute12 = g_asg_table_id,
2868: attribute13 = g_person_type_table_id -- Dated table id of PER_PERSON_TYPE_USAGES_F
2869: WHERE mthd_action_id = p_mthd_action_id;
2870: --
2871: dbg('Completed storing the parameter values for use by the slave processes ...');
2872: --