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_SG_AEI_LEG_HOOK dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 58: FROM per_assignment_extra_info

54: (p_assignment_id number,
55: p_information_type varchar2,
56: p_aei_information1 varchar2) is
57: SELECT 'X'
58: FROM per_assignment_extra_info
59: WHERE assignment_id = p_assignment_id
60: AND information_type = p_information_type
61: AND aei_information1 = p_aei_information1
62: HAVING count(*) > 3;

Line 319: FROM per_assignment_extra_info

315: p_aei_information1 varchar2,
316: p_aei_information2 varchar2,
317: p_aei_information3 varchar2) is
318: SELECT 'X'
319: FROM per_assignment_extra_info
320: WHERE assignment_id = p_assignment_id
321: AND information_type = p_information_type
322: AND aei_information1 = p_aei_information1
323: AND ((fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00'))

Line 336: FROM per_assignment_extra_info

332: p_aei_information1 varchar2,
333: p_aei_information2 varchar2,
334: p_aei_information3 varchar2) is
335: SELECT 'X'
336: FROM per_assignment_extra_info
337: WHERE assignment_id = p_assignment_id
338: AND information_type = p_information_type
339: AND substr(aei_information1,11,3) = substr(p_aei_information1,11,3)
340: AND ((fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00'))