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 75: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

71: g_validate varchar2(30) := fnd_profile.value('BEN_CWB_ASG_PERF_VALIDATE');
72:
73:
74: FUNCTION get_update_mode(
75: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
76: ,p_ovn IN per_all_assignments_f.object_version_number%TYPE
77: ,p_effective_date IN DATE
78: )
79: RETURN VARCHAR2

Line 76: ,p_ovn IN per_all_assignments_f.object_version_number%TYPE

72:
73:
74: FUNCTION get_update_mode(
75: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
76: ,p_ovn IN per_all_assignments_f.object_version_number%TYPE
77: ,p_effective_date IN DATE
78: )
79: RETURN VARCHAR2
80: IS

Line 2630: l_comment_id per_all_assignments_f.comment_id%TYPE;

2626: l_assignment_id number;
2627: l_datetrack_mode varchar2(30);
2628: l_concat_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
2629: l_group_name pay_people_groups.group_name%TYPE;
2630: l_comment_id per_all_assignments_f.comment_id%TYPE;
2631: l_no_mgr_warning boolean;
2632: l_othr_mgr_warning boolean;
2633: l_spp_delete_warning boolean;
2634: l_tax_dist_changed boolean;

Line 2643: from per_all_assignments_f asg

2639: l_update_done boolean := false;
2640: --
2641: cursor c_asg is
2642: select asg.*
2643: from per_all_assignments_f asg
2644: where asg.assignment_id = l_assignment_id
2645: and l_effective_date between
2646: asg.effective_start_date and asg.effective_end_date;
2647: l_asg_rec c_asg%rowtype;