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_EVS_MAG_REPORT dependencies on HR_ORGANIZATION_INFORMATION

Line 76: hr_organization_information hoi

72: CURSOR c_gre(p_business_group_id IN NUMBER) IS
73: SELECT hou.organization_id organization_id,
74: hou.name org_name
75: FROM hr_all_organization_units hou,
76: hr_organization_information hoi
77: WHERE hou.business_group_id = p_business_group_id
78: AND hou.organization_id = hoi.organization_id
79: AND hoi.org_information_context = 'CLASS'
80: AND hoi.org_information1 = 'HR_LEGAL';

Line 86: hr_organization_information hoi

82: CURSOR c_get_requester_code(p_organization_id IN NUMBER) IS
83: SELECT hoi.org_information1 requester_code,
84: hou.name org_name
85: FROM hr_all_organization_units hou,
86: hr_organization_information hoi
87: WHERE hoi.organization_id = hou.organization_id
88: AND hoi.organization_id = p_organization_id
89: AND hoi.org_information_context = 'EVS Filing';
90:

Line 167: ,hr_organization_information hoi

163: FROM per_all_people_f ppf
164: ,per_all_assignments_f paf
165: ,hr_soft_coding_keyflex hsck
166: ,hr_organization_units hou
167: ,hr_organization_information hoi
168: WHERE paf.assignment_type = ''E''
169: AND paf.primary_flag = ''Y''
170: AND paf.effective_start_date <= to_date('''||g_end_date||''',''YYYY/MM/DD/'')
171: AND paf.effective_end_date >= to_date('''||g_start_date||''',''YYYY/MM/DD/'')

Line 198: ,hr_organization_information hoi

194: from per_all_people_f ppf
195: ,per_all_assignments_f paf
196: ,hr_soft_coding_keyflex hsck
197: ,hr_organization_units hou
198: ,hr_organization_information hoi
199: where paf.assignment_type = ''E''
200: and paf.primary_flag = ''Y''
201: and paf.effective_start_date <= to_date('''||g_end_date||''',''YYYY/MM/DD/'')
202: and paf.effective_end_date >= to_date('''||g_start_date||''',''YYYY/MM/DD/'')

Line 234: from hr_organization_information hoi

230: and paf.effective_end_date >= to_date('''|| g_start_date||''',''YYYY/MM/DD/'')
231: and hsck.segment1 in
232: (
233: select distinct hsck2.segment1
234: from hr_organization_information hoi
235: ,hr_organization_units hou
236: ,hr_soft_coding_keyflex hsck2
237: where
238: hou.business_group_id +0 = ' || g_business_group_id || '

Line 304: hr_organization_information hoi

300: and hsck.segment1 in
301: (
302: select distinct hsck2.segment1
303: from
304: hr_organization_information hoi
305: ,hr_organization_units hou
306: ,hr_soft_coding_keyflex hsck2
307: where
308: hou.business_group_id +0 = g_business_group_id

Line 343: hr_organization_information hoi,

339: from per_all_people_f ppf ,
340: per_all_assignments_f paf,
341: hr_soft_coding_keyflex hsck,
342: hr_all_organization_units hou,
343: hr_organization_information hoi,
344: per_assignment_status_types past
345: where paf.assignment_type = 'E'
346: and paf.primary_flag = 'Y'
347: and paf.effective_start_date <= to_date(g_end_date,'YYYY/MM/DD/')

Line 403: from hr_organization_information hoi

399: )
400: and hsck.segment1 in
401: (
402: select distinct hsck2.segment1
403: from hr_organization_information hoi
404: ,hr_organization_units hou
405: ,hr_soft_coding_keyflex hsck2
406: where
407: hou.business_group_id +0 = g_business_group_id

Line 432: ,hr_organization_information hoi

428: from per_all_people_f ppf
429: ,per_all_assignments_f paf
430: ,hr_soft_coding_keyflex hsck
431: ,hr_organization_units hou
432: ,hr_organization_information hoi
433: ,per_assignment_status_types past
434: where paf.assignment_type = 'E'
435: and paf.primary_flag = 'Y'
436: and paf.effective_start_date <= to_date(g_end_date,'YYYY/MM/DD/')

Line 511: from hr_organization_information hoi

507: )
508: and hsck.segment1 in
509: (
510: select distinct hsck2.segment1
511: from hr_organization_information hoi
512: ,hr_organization_units hou
513: ,hr_soft_coding_keyflex hsck2
514: where
515: hou.business_group_id +0 = g_business_group_id

Line 1214: from hr_organization_information hoi

1210: select distinct hou.name -- BUG4192188
1211: ,hsck.segment1 tax_unit_id
1212: ,hoi2.org_information1 requester_id_code
1213: ,hoi2.org_information2 user_control_data
1214: from hr_organization_information hoi
1215: ,hr_organization_units hou
1216: ,hr_soft_coding_keyflex hsck
1217: ,hr_organization_information hoi2
1218: where hou.business_group_id = p_business_group_id

Line 1217: ,hr_organization_information hoi2

1213: ,hoi2.org_information2 user_control_data
1214: from hr_organization_information hoi
1215: ,hr_organization_units hou
1216: ,hr_soft_coding_keyflex hsck
1217: ,hr_organization_information hoi2
1218: where hou.business_group_id = p_business_group_id
1219: and hsck.segment1 = to_char(hou.organization_id)
1220: and hoi.organization_id = hou.organization_id
1221: and hoi.org_information_context = 'CLASS'

Line 1236: hr_organization_information hoi

1232: hoi.org_information1 requester_id_code
1233: ,hoi.org_information2 user_control_data
1234: ,hou.name name
1235: FROM
1236: hr_organization_information hoi
1237: ,hr_organization_units hou
1238: WHERE
1239: hoi.organization_id = p_tax_unit_id
1240: AND hoi.org_information_context = 'EVS Filing'