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

Line 474: from per_assignments_f x

470: ,p_date date
471: ,p_date_type varchar2) is
472: cursor c is
473: select 'x'
474: from per_assignments_f x
475: where x.assignment_id = p_assignment_id
476: and p_date >=
477: (select min(y.effective_start_date)
478: from per_assignments_f y

Line 478: from per_assignments_f y

474: from per_assignments_f x
475: where x.assignment_id = p_assignment_id
476: and p_date >=
477: (select min(y.effective_start_date)
478: from per_assignments_f y
479: where y.assignment_id = x.assignment_id)
480: and p_date <=
481: (select max(y.effective_end_date)
482: from per_assignments_f y

Line 482: from per_assignments_f y

478: from per_assignments_f y
479: where y.assignment_id = x.assignment_id)
480: and p_date <=
481: (select max(y.effective_end_date)
482: from per_assignments_f y
483: where y.assignment_id = x.assignment_id);
484: --
485: l_exists varchar2(1);
486: begin

Line 516: from per_assignments_f

512: function set_end_date(p_assignment_id number
513: ,p_end_date date) return date is
514: cursor c is
515: select max(effective_end_date)
516: from per_assignments_f
517: where assignment_id = p_assignment_id;
518: --
519: l_new_end_date date;
520: begin