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.HRI_EDW_FCT_RECRUITMENT dependencies on HR_LOOKUPS

Line 159: /* 115.3 Added hr_lookups to cursor below to filter out rogue reasons */

155: RETURN VARCHAR2 IS
156:
157: l_reason VARCHAR2(400);
158:
159: /* 115.3 Added hr_lookups to cursor below to filter out rogue reasons */
160: /* See bugs 1787981 and 1785779 */
161:
162: /* Looking at the applicant assignment */
163: CURSOR smpl_hire_reason_cur IS

Line 168: hr_lookups hrl

164: SELECT
165: asg.change_reason
166: FROM
167: per_all_assignments_f asg,
168: hr_lookups hrl
169: WHERE
170: asg.assignment_id = p_assignment_id
171: AND asg.change_reason = hrl.lookup_code
172: AND hrl.lookup_type = 'EMP_ASSIGN_REASON'

Line 181: hr_lookups hrl

177: SELECT
178: asg.change_reason
179: FROM
180: per_all_assignments_f asg,
181: hr_lookups hrl
182: WHERE
183: asg.person_id = p_person_id
184: AND asg.effective_start_date = p_hire_date
185: AND asg.change_reason = hrl.lookup_code