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.BEN_CWB_ASG_UPDATE dependencies on PER_ALL_ASSIGNMENTS_F

Line 80: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

76: g_validate varchar2(30) := fnd_profile.value('BEN_CWB_ASG_PERF_VALIDATE');
77:
78:
79: FUNCTION get_update_mode(
80: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
81: ,p_ovn IN per_all_assignments_f.object_version_number%TYPE
82: ,p_effective_date IN DATE
83: )
84: RETURN VARCHAR2

Line 81: ,p_ovn IN per_all_assignments_f.object_version_number%TYPE

77:
78:
79: FUNCTION get_update_mode(
80: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
81: ,p_ovn IN per_all_assignments_f.object_version_number%TYPE
82: ,p_effective_date IN DATE
83: )
84: RETURN VARCHAR2
85: IS

Line 2643: l_comment_id per_all_assignments_f.comment_id%TYPE;

2639: l_assignment_id number;
2640: l_datetrack_mode varchar2(30);
2641: l_concat_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
2642: l_group_name pay_people_groups.group_name%TYPE;
2643: l_comment_id per_all_assignments_f.comment_id%TYPE;
2644: l_no_mgr_warning boolean;
2645: l_othr_mgr_warning boolean;
2646: l_spp_delete_warning boolean;
2647: l_tax_dist_changed boolean;

Line 2656: from per_all_assignments_f asg

2652: l_update_done boolean := false;
2653: --
2654: cursor c_asg is
2655: select asg.*
2656: from per_all_assignments_f asg
2657: where asg.assignment_id = l_assignment_id
2658: and l_effective_date between
2659: asg.effective_start_date and asg.effective_end_date;
2660: l_asg_rec c_asg%rowtype;