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.HR_ASSIGNMENT_ATT dependencies on HR_COMMENTS

Line 190: from hr_comments hc

186: ,asg.vendor_assignment_number
187: ,asg.vendor_employee_number
188: ,asg.vendor_id
189: ,asg.soft_coding_keyflex_id
190: from hr_comments hc
191: , per_all_assignments_f asg
192: where asg.assignment_id=p_assignment_id
193: and asg.effective_end_date >= l_constant_effective_date
194: and hc.comment_id(+) = asg.comment_id

Line 261: from hr_comments hc

257: ,asg.vendor_assignment_number
258: ,asg.vendor_employee_number
259: ,asg.vendor_id
260: ,asg.soft_coding_keyflex_id
261: from hr_comments hc
262: , per_all_assignments_f asg
263: where asg.assignment_id=p_assignment_id
264: and asg.effective_end_date < l_constant_effective_date
265: and hc.comment_id(+) = asg.comment_id

Line 276: l_comments hr_comments.comment_text%TYPE;

272: order by asg.effective_end_date asc;
273:
274: -- IN parameters for API
275: l_asg_rec per_all_assignments_f%rowtype;
276: l_comments hr_comments.comment_text%TYPE;
277: -- OUT parameters for API
278: l_soft_coding_keyflex_id number;
279: l_comment_id number;
280: l_effective_start_date date;