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_PAY_CAPS dependencies on PER_ALL_ASSIGNMENTS_F

Line 157: CURSOR cur_per_org_det (p_per_id per_all_assignments_f.person_id%TYPE,

153: --
154: -- Bug 4063133
155: -- PERFORMANCE CERTIFICATION CURSOR DECLARATIONS START HERE
156: --
157: CURSOR cur_per_org_det (p_per_id per_all_assignments_f.person_id%TYPE,
158: p_eff_date per_all_assignments_f.effective_start_date%TYPE)
159: IS
160: SELECT asg.organization_id
161: FROM per_all_assignments_f asg

Line 158: p_eff_date per_all_assignments_f.effective_start_date%TYPE)

154: -- Bug 4063133
155: -- PERFORMANCE CERTIFICATION CURSOR DECLARATIONS START HERE
156: --
157: CURSOR cur_per_org_det (p_per_id per_all_assignments_f.person_id%TYPE,
158: p_eff_date per_all_assignments_f.effective_start_date%TYPE)
159: IS
160: SELECT asg.organization_id
161: FROM per_all_assignments_f asg
162: WHERE asg.person_id = p_per_id

Line 161: FROM per_all_assignments_f asg

157: CURSOR cur_per_org_det (p_per_id per_all_assignments_f.person_id%TYPE,
158: p_eff_date per_all_assignments_f.effective_start_date%TYPE)
159: IS
160: SELECT asg.organization_id
161: FROM per_all_assignments_f asg
162: WHERE asg.person_id = p_per_id
163: AND asg.assignment_type <> 'B'
164: AND trunc(p_eff_date) between asg.effective_start_date
165: and asg.effective_end_date;