APPS.HRI_OPL_EVENT_CAPTURE dependencies on PER_ALL_ASSIGNMENTS_F

Line 489: -- per_all_assignments_f but does exist in hri_mb_asgn_events_ct

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

Line 493: FROM per_all_assignments_f asgn

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

Line 501: FROM per_all_assignments_f asgn

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

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

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

Line 986: FROM per_all_assignments_f

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

Line 2387: FROM per_all_assignments_f

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

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

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

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

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