APPS.HRI_OPL_EVENT_CAPTURE dependencies on PER_ALL_ASSIGNMENTS_F

Line 492: -- per_all_assignments_f but does exist in hri_mb_asgn_events_ct

488: -- Note: extension starts one day after the projected assignment end specified
489: -- in the assignment record
490: --
491: -- Bug 4533293 - return event date (using NVL) if no projected end date exists in
492: -- per_all_assignments_f but does exist in hri_mb_asgn_events_ct
493: --
494: CURSOR c_extsn_strt_dt IS
495: SELECT asgn.person_id, NVL(min(asgn.projected_assignment_end) + 1, p_effective_date)
496: FROM per_all_assignments_f asgn

Line 496: FROM per_all_assignments_f asgn

492: -- per_all_assignments_f but does exist in hri_mb_asgn_events_ct
493: --
494: CURSOR c_extsn_strt_dt IS
495: SELECT asgn.person_id, NVL(min(asgn.projected_assignment_end) + 1, p_effective_date)
496: FROM per_all_assignments_f asgn
497: WHERE primary_flag = 'Y'
498: --
499: -- For people with multiple placement (rehire), the extsn date specified during
500: -- a particular term should only be considered for evaluating the extsn date

Line 504: FROM per_all_assignments_f asgn

500: -- a particular term should only be considered for evaluating the extsn date
501: --
502: AND (person_id,period_of_placement_date_start) =
503: ( SELECT asgn.person_id , asgn.period_of_placement_date_start
504: FROM per_all_assignments_f asgn
505: WHERE asgn.assignment_id = p_assignment_id
506: AND rownum = 1)
507: GROUP BY asgn.person_id
508: --

Line 697: -- 3170971, extending the case to per_all_assignments_f, In case of cancel hire of an

693: -- of the old-new hire dates i.e. 01-jan-2004 in this case. This will ensure that old
694: -- data for the assignment is delete by the collection processes.
695: -- 3952026, extended the case to change in effective date of other non datetrack tables
696: -- per_appraisals and per_periods_of_service
697: -- 3170971, extending the case to per_all_assignments_f, In case of cancel hire of an
698: -- applicant, the previously end dated applicant asg record is end dated to end of
699: -- time from current date and the asg record is deleted. However PEM will detect only
700: -- the update of effective_end_date column
701: --

Line 989: FROM per_all_assignments_f

985: RETURN NUMBER IS
986: --
987: CURSOR c_business_group(p_assignment_id IN VARCHAR2) IS
988: SELECT business_group_id
989: FROM per_all_assignments_f
990: WHERE assignment_id = p_assignment_id;
991: --
992: l_business_group_id NUMBER;
993: --

Line 2390: FROM per_all_assignments_f

2386: IS
2387: --
2388: CURSOR asg_csr IS
2389: SELECT DISTINCT assignment_id
2390: FROM per_all_assignments_f
2391: WHERE assignment_type = 'E'
2392: AND business_group_id = NVL(p_business_group_id, business_group_id)
2393: AND (effective_start_date >= p_collect_from
2394: OR effective_end_date >= p_collect_from);

Line 2431: g_asg_table_id := get_dated_table_id('PER_ALL_ASSIGNMENTS_F');

2427: --
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: --

Line 2842: g_asg_table_id := get_dated_table_id('PER_ALL_ASSIGNMENTS_F');

2838: --
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