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.GHR_VALIDATE_PERWSDPO dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 318: select assignment_id from per_assignment_extra_info

314: -- --------------------------------------------------------------------------
315: FUNCTION chk_det_pos_exists (p_position_id in number) RETURN BOOLEAN IS
316:
317: cursor c_det_pos_exists is
318: select assignment_id from per_assignment_extra_info
319: where information_type = 'GHR_US_ASG_DET_INFO'
320: and to_number(aei_information5) = p_position_id;
321:
322: begin

Line 340: select assignment_id from per_assignment_extra_info

336: FUNCTION chk_detail_next (p_position_id in number,
337: p_effective_date in date) RETURN BOOLEAN IS
338:
339: cursor c_det_pos_next is
340: select assignment_id from per_assignment_extra_info
341: where information_type = 'GHR_US_ASG_DET_INFO'
342: and to_number(aei_information5) = p_position_id
343: and p_effective_date <= fnd_date.canonical_to_date(aei_information2);
344: