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 156: CURSOR cur_per_org_det (p_per_id per_all_assignments_f.person_id%TYPE,

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

Line 157: p_eff_date per_all_assignments_f.effective_start_date%TYPE)

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

Line 160: FROM per_all_assignments_f asg

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