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_APPLICANT_DATAUPD dependencies on PER_ALL_ASSIGNMENTS_F

Line 68: FROM per_all_assignments_f paf

64: WHERE appl.rowid between p_start_rowid and p_end_rowid
65: AND date_end IS NOT NULL
66: AND EXISTS
67: (SELECT 'Y'
68: FROM per_all_assignments_f paf
69: WHERE paf.application_id = appl.application_id
70: AND paf.assignment_type = 'A'
71: AND paf.effective_end_date > appl.date_end)
72: ORDER BY date_end DESC;

Line 99: FROM per_all_assignments_f paf

95: for update of ptu.person_type_id nowait; -- #4919613
96: --
97: CURSOR csr_get_ended_asg(p_application_id number, p_termination_date date) IS
98: SELECT count(assignment_id)
99: FROM per_all_assignments_f paf
100: WHERE paf.application_id = p_application_id
101: AND paf.assignment_type = 'A'
102: AND paf.effective_end_date > p_termination_date
103: AND paf.effective_end_date <> hr_general.end_of_time

Line 106: from per_all_assignments_f paf2

102: AND paf.effective_end_date > p_termination_date
103: AND paf.effective_end_date <> hr_general.end_of_time
104: AND paf.effective_start_date =
105: (select max(effective_start_date) -- do not consider DT updates
106: from per_all_assignments_f paf2
107: where paf2.assignment_id = paf.assignment_id
108: and paf2.effective_end_date > p_termination_date);
109: --
110: CURSOR csr_get_affected_asg(p_application_id number, p_termination_date date) IS

Line 112: FROM per_all_assignments_f paf

108: and paf2.effective_end_date > p_termination_date);
109: --
110: CURSOR csr_get_affected_asg(p_application_id number, p_termination_date date) IS
111: SELECT count(assignment_id)
112: FROM per_all_assignments_f paf
113: WHERE paf.application_id = p_application_id
114: AND paf.assignment_type = 'A'
115: AND paf.effective_end_date > p_termination_date
116: AND paf.effective_start_date =

Line 118: from per_all_assignments_f paf2

114: AND paf.assignment_type = 'A'
115: AND paf.effective_end_date > p_termination_date
116: AND paf.effective_start_date =
117: (select max(effective_start_date) -- do not consider DT updates
118: from per_all_assignments_f paf2
119: where paf2.assignment_id = paf.assignment_id
120: and paf2.effective_end_date > p_termination_date);
121: --
122: --