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.GHR_PER_SUM dependencies on PER_ASSIGNMENTS_F

Line 529: from per_assignments_f

525:
526: -- Commented the below cursor as a part of bug 4016362
527: /*Cursor Cur_bg(p_assignment_id NUMBER,p_eff_date DATE) is
528: Select distinct business_group_id bg
529: from per_assignments_f
530: where assignment_id = p_assignment_id
531: and p_eff_date between effective_start_date
532: and effective_end_date;
533: --

Line 731: ,per_assignments_f asg

727: CURSOR cur_dob_asgstat IS
728: SELECT per.date_of_birth
729: ,ast.per_system_status
730: FROM per_assignment_status_types ast
731: ,per_assignments_f asg
732: ,per_people_f per
733: WHERE asg.assignment_id = p_assignment_id
734: AND asg.person_id = per.person_id
735: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 798: from per_assignments_f

794: CURSOR cur_payroll_start IS
795: select start_date
796: from per_time_periods ptp
797: where payroll_id in (select payroll_id
798: from per_assignments_f
799: where assignment_id = p_assignment_id
800: and trunc(p_effective_date) between effective_start_date
801: and effective_end_date)
802: and trunc(p_effective_date) between start_date and end_date;