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_ASSIGNMENT_STATUS_TYPES

Line 111: from per_assignment_status_types ast

107: , cp_eff_date DATE )
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

Line 289: from per_assignment_status_types ast

285: , asg.assignment_id
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

Line 303: from per_assignment_status_types ast2

299: and asg.assignment_status_type_id = ast.assignment_status_type_id
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

Line 320: from per_assignment_status_types ast

316: , asg.assignment_id
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

Line 334: from per_assignment_status_types ast2

330: and asg.assignment_status_type_id = ast.assignment_status_type_id
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

Line 351: from per_assignment_status_types ast

347: , asg.assignment_id
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

Line 365: from per_assignment_status_types ast2

361: and asg.assignment_status_type_id = ast.assignment_status_type_id
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

Line 577: from per_assignment_status_types ast

573: , cp_report_date DATE )
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

Line 757: from per_assignment_status_types ast

753: , cp_report_date DATE )
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