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 740: ,per_assignments_f asg

736: CURSOR cur_dob_asgstat IS
737: SELECT per.date_of_birth
738: ,ast.per_system_status
739: FROM per_assignment_status_types ast
740: ,per_assignments_f asg
741: ,per_people_f per
742: WHERE asg.assignment_id = p_assignment_id
743: AND asg.person_id = per.person_id
744: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 807: from per_assignments_f

803: CURSOR cur_payroll_start IS
804: select start_date
805: from per_time_periods ptp
806: where payroll_id in (select payroll_id
807: from per_assignments_f
808: where assignment_id = p_assignment_id
809: and trunc(p_effective_date) between effective_start_date
810: and effective_end_date)
811: and trunc(p_effective_date) between start_date and end_date;