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_BIS_ORG_PERF dependencies on HRI_ORG_PARAM_LIST

Line 113: , hri_org_param_list opl

109: select opl.organization_id_group organization_id -- S.Bhattal, 19/07/99
110: , asg.assignment_id
111: from per_assignment_status_types ast
112: , per_assignments_f asg
113: , hri_org_param_list opl
114: where opl.org_param_id = cp_org_param_id
115: and opl.organization_id_child = asg.organization_id
116: and cp_eff_date between asg.effective_start_date and
117: asg.effective_end_date

Line 127: , hri_org_param_list opl

123: ( cp_org_param_id NUMBER )
124: is
125: select org.organization_id
126: from hr_organization_units org
127: , hri_org_param_list opl
128: where opl.org_param_id = cp_org_param_id
129: and opl.organization_id_child = org.organization_id
130: group by org.organization_id; -- S.Bhattal, 19/07/99
131:

Line 292: , hri_org_param_list opl

288: , 0 loss
289: from per_assignment_status_types ast
290: , per_assignments_f asg
291: , hr_all_organization_units org
292: , hri_org_param_list opl
293: where opl.org_param_id = cp_org_param_id
294: and opl.organization_id_group = cp_org_id
295: and opl.organization_id_child = asg.organization_id
296: and org.organization_id = asg.organization_id

Line 305: , hri_org_param_list opl2

301: and exists (
302: select 1
303: from per_assignment_status_types ast2
304: , per_assignments_f asg2
305: , hri_org_param_list opl2
306: where opl2.org_param_id = cp_org_param_id
307: and opl2.organization_id_group = cp_org_id
308: and opl2.organization_id_child = asg2.organization_id
309: and asg2.assignment_id = asg.assignment_id

Line 323: , hri_org_param_list opl

319: , 0 loss
320: from per_assignment_status_types ast
321: , per_assignments_f asg
322: , hr_all_organization_units org
323: , hri_org_param_list opl
324: where opl.org_param_id = cp_org_param_id
325: and opl.organization_id_group = cp_org_id
326: and opl.organization_id_child = asg.organization_id
327: and org.organization_id = asg.organization_id

Line 336: , hri_org_param_list opl2

332: and not exists (
333: select 1
334: from per_assignment_status_types ast2
335: , per_assignments_f asg2
336: , hri_org_param_list opl2
337: where opl2.org_param_id = cp_org_param_id
338: and opl2.organization_id_group = cp_org_id
339: and opl2.organization_id_child = asg2.organization_id
340: and asg2.assignment_id=asg.assignment_id

Line 354: , hri_org_param_list opl

350: , 1 loss
351: from per_assignment_status_types ast
352: , per_assignments_f asg
353: , hr_all_organization_units org
354: , hri_org_param_list opl
355: where opl.org_param_id = cp_org_param_id
356: and opl.organization_id_group = cp_org_id
357: and opl.organization_id_child = asg.organization_id
358: and org.organization_id = asg.organization_id

Line 367: , hri_org_param_list opl2

363: and not exists (
364: select 1
365: from per_assignment_status_types ast2
366: , per_assignments_f asg2
367: , hri_org_param_list opl2
368: where opl2.org_param_id = cp_org_param_id
369: and opl2.organization_id_group = cp_org_id
370: and opl2.organization_id_child = asg2.organization_id
371: and asg2.assignment_id=asg.assignment_id

Line 382: , hri_org_param_list opl

378: ( cp_org_param_id NUMBER )
379: is
380: select org.organization_id
381: from hr_organization_units org
382: , hri_org_param_list opl
383: where opl.org_param_id = cp_org_param_id
384: and opl.organization_id_child = org.organization_id
385: group by org.organization_id; -- S.Bhattal, 19/07/99
386: