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.HREMPTER dependencies on PER_ASSIGNMENTS_F

Line 108: term_assign row in per_assignments_f.

104: pay_element_entries_f with
105: sysdate.
106: 70.23 26-JUL-95 RFine 291763 Added missing column PAY_BASIS_ID to
107: the SQL statement which inserts the new
108: term_assign row in per_assignments_f.
109: It was missing, with the effective
110: result that terminating the person also
111: cleared the assignments' pay basis.
112: 70.24 29-AUG-95 RFine 270356 Get the default TERM_ASSIGN status

Line 143: explicit insert for per_assignments_f.

139: procedure to state from 70.28
140: 70.31 18-Mar-1996 Vtreiger Fixed a bug in post_update for
141: terminate_employee procedure.
142: 70.32 15-Apr-1996 VTreiger 354874 Included employment category in the
143: explicit insert for per_assignments_f.
144: 70.33 15-May-1996 VTreiger 364214 Included additional criteria for
145: function check_for_future_actions
146: 70.34 22-May-1996 VTreiger 364214 Restored back to version 70.32.
147: 70.35 04-Jun-1996 VTreiger 364214 Added function check_for_compl_actions.

Line 199: PER_ASSIGNMENTS_F during the post update

195: 115.10 06-MAR-2000 Rvydyana Leapfroged version of v115.8 with code fix
196: for 1176101 ie. Added call to
197: ben_dt_trg_handle in cancel termination.
198: 115.11 16-NOV-1999 I Harding 1076054 Added extra attributes to insert into
199: PER_ASSIGNMENTS_F during the post update
200: work following a termination of an
201: employee. Requested by John Rhodes
202: following French Phase 1.
203: 115.12 13-MAR-2000 CSimpson Added town_of_birth, region_of_birth,

Line 548: FROM per_assignments_f

544: AND pev.date_start > p_actual_termination_date
545: AND pev.event_or_interview = 'I'
546: AND pev.assignment_id IS NOT NULL
547: AND pev.assignment_id NOT IN (SELECT assignment_id
548: FROM per_assignments_f
549: WHERE person_id = p_person_id
550: )
551: );
552: --

Line 575: DELETE per_assignments_f ass

571: begin
572: hr_utility.trace('Entered delete_de_assign for '||p_assignment_id);
573: --
574: hr_utility.set_location(l_proc,1);
575: DELETE per_assignments_f ass
576: WHERE ass.assignment_id = p_assignment_id
577: AND ass.effective_start_date > p_delete_date;
578: --
579: end delete_de_assign;

Line 597: FROM per_assignments_f ass

593: --
594: hr_utility.set_location(l_proc,1);
595: SELECT max(ass.effective_end_date)
596: INTO l_max_end_date
597: FROM per_assignments_f ass
598: WHERE ass.assignment_id = p_assignment_id;
599: --
600: return l_max_end_date;
601: --

Line 630: per_assignments_f asg

626: WHERE exists
627: (SELECT null
628: FROM pay_payroll_actions pac,
629: pay_assignment_actions act,
630: per_assignments_f asg
631: WHERE asg.person_id = p_person_id
632: AND act.assignment_id = asg.assignment_id
633: AND pac.payroll_action_id = act.payroll_action_id
634: AND pac.action_type <> 'BEE'

Line 684: per_assignments_f asg

680: WHERE exists
681: (SELECT null
682: FROM pay_payroll_actions pac,
683: pay_assignment_actions act,
684: per_assignments_f asg
685: WHERE asg.person_id = p_person_id
686: AND act.assignment_id = asg.assignment_id
687: AND pac.payroll_action_id = act.payroll_action_id
688: AND pac.action_type NOT IN ('X','BEE') -- Bug 889806, 2711532

Line 703: per_assignments_f asg

699: WHERE exists
700: (SELECT null
701: FROM pay_payroll_actions pac,
702: pay_assignment_actions act,
703: per_assignments_f asg
704: WHERE asg.person_id = p_person_id
705: AND act.assignment_id = asg.assignment_id
706: AND pac.payroll_action_id = act.payroll_action_id
707: AND pac.action_status = 'C'

Line 898: -- from per_assignments_f a

894: -- into l_cobra_benefits_exist
895: -- from sys.dual
896: -- where exists
897: -- (select null
898: -- from per_assignments_f a
899: -- , per_cobra_cov_enrollments e
900: -- , per_cobra_coverage_benefits_f b
901: -- where a.person_id = p_person_id
902: -- and p_final_process_date between

Line 2140: FROM per_assignments_f ass

2136: -- Added AND assignment_type = 'E' 307957 tm 19-sep-1995
2137: --
2138: CURSOR c_assignment IS
2139: SELECT *
2140: FROM per_assignments_f ass
2141: WHERE ass.person_id = p_person_id
2142: AND p_actual_termination_date
2143: BETWEEN ass.effective_start_date
2144: AND ass.effective_end_date

Line 2644: UPDATE per_assignments_f

2640: hrempter.delete_de_assign(c_ass_rec.assignment_id
2641: ,p_final_process_date);
2642: --
2643: hr_utility.set_location(l_proc,95);
2644: UPDATE per_assignments_f
2645: SET effective_end_date = p_final_process_date
2646: WHERE CURRENT OF c_assignment;
2647: --
2648: hr_utility.set_location(l_proc,1200);

Line 2692: INSERT INTO per_assignments_f

2688: end if;
2689: --
2690: hr_utility.set_location(l_proc,108);
2691: -- VT 04/12/96 bug #354874 added EMPLOYMENT_CATEGORY processing
2692: INSERT INTO per_assignments_f
2693: ( ASSIGNMENT_ID
2694: , EFFECTIVE_START_DATE
2695: , EFFECTIVE_END_DATE
2696: , BUSINESS_GROUP_ID

Line 2900: UPDATE per_assignments_f ass

2896: , c_ass_rec.EMPLOYEE_CATEGORY
2897: , c_ass_rec.JOB_POST_SOURCE_NAME);
2898: --
2899: hr_utility.set_location(l_proc,110);
2900: UPDATE per_assignments_f ass
2901: SET ass.effective_end_date = p_actual_termination_date
2902: WHERE CURRENT OF c_assignment;
2903: --
2904: end if;

Line 2956: FROM per_assignments_f ass

2952: l_ent_loop VARCHAR2(1) := 'N';
2953: --
2954: CURSOR c_assignment IS
2955: SELECT ass.assignment_id
2956: FROM per_assignments_f ass
2957: WHERE ass.person_id = p_person_id
2958: AND p_final_process_date
2959: BETWEEN ass.effective_start_date
2960: AND ass.effective_end_date

Line 3061: UPDATE per_assignments_f ass

3057: hrempter.delete_de_assign(c_ass_rec.assignment_id
3058: ,p_final_process_date);
3059: --
3060: hr_utility.set_location(l_proc,40);
3061: UPDATE per_assignments_f ass
3062: SET ass.effective_end_date = p_final_process_date
3063: WHERE CURRENT OF c_assignment;
3064: end if;
3065: --

Line 3368: FROM per_assignments_f ass

3364: CURSOR c_assignment IS
3365: SELECT assignment_id
3366: , assignment_status_type_id
3367: , business_group_id
3368: FROM per_assignments_f ass
3369: WHERE ass.person_id = p_person_id
3370: AND ass.effective_end_date = p_actual_termination_date
3371: FOR UPDATE;
3372: */

Line 3383: FROM per_assignments_f ass

3379: , effective_start_date
3380: , effective_end_date
3381: , payroll_id
3382: , object_version_number
3383: FROM per_assignments_f ass
3384: WHERE ass.person_id = p_person_id
3385: AND ass.effective_end_date = p_actual_termination_date
3386: FOR UPDATE;
3387: --

Line 3728: UPDATE per_assignments_f ass

3724: l_effective_end_date1 := c_ass_rec.effective_end_date;
3725: l_effective_start_date1:=c_ass_rec.effective_start_date;
3726: -- end of bug fix 4919804
3727:
3728: UPDATE per_assignments_f ass
3729: SET ass.effective_end_date = l_effective_end_date
3730: WHERE assignment_id = c_ass_rec.assignment_id
3731: AND effective_end_date = l_max_end_date;
3732:

Line 3881: UPDATE per_assignments_f ass

3877: -- AOL WHO and OVN columns.
3878: --
3879: -- First update all future assignments to set the assignment status...
3880: --
3881: UPDATE per_assignments_f ass
3882: SET ass.assignment_status_type_id = l_asg_status_type_id
3883: WHERE assignment_id = c_ass_rec.assignment_id
3884: AND effective_start_date >= p_actual_termination_date;
3885: --