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 PER_ASSIGNMENTS_F

Line 112: , per_assignments_f asg

108: is
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

Line 290: , per_assignments_f asg

286: , 1 no_change
287: , 0 gain
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

Line 304: , per_assignments_f asg2

300: and ast.per_system_status = 'ACTIVE_ASSIGN'
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

Line 321: , per_assignments_f asg

317: , 0 no_change
318: , 1 gain
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

Line 335: , per_assignments_f asg2

331: and ast.per_system_status = 'ACTIVE_ASSIGN'
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

Line 352: , per_assignments_f asg

348: , 0 no_change
349: , 0 gain
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

Line 366: , per_assignments_f asg2

362: and ast.per_system_status = 'ACTIVE_ASSIGN'
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

Line 578: , per_assignments_f asg

574: is
575: select asg.organization_id
576: , asg.assignment_id
577: from per_assignment_status_types ast
578: , per_assignments_f asg
579: where cp_report_date between asg.effective_start_date and asg.effective_end_date
580: and asg.assignment_type = 'E'
581: and ast.assignment_status_type_id = asg.assignment_status_type_id
582: and ast.per_system_status = 'ACTIVE_ASSIGN'

Line 758: , per_assignments_f asg

754: is
755: select asg.organization_id
756: , asg.assignment_id
757: from per_assignment_status_types ast
758: , per_assignments_f asg
759: where cp_report_date between asg.effective_start_date and asg.effective_end_date
760: and asg.assignment_type = 'E'
761: and ast.assignment_status_type_id = asg.assignment_status_type_id
762: and ast.per_system_status = 'ACTIVE_ASSIGN'