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.PER_CA_EMP_EQUITY_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 310: per_assignment_status_types past,

306: from per_pay_bases ppb,
307: per_all_assignments_f paf,
308: per_all_people_f ppf,
309: per_pay_proposals_v2 pppv,
310: per_assignment_status_types past,
311: hr_lookups hrl
312: where paf.pay_basis_id = ppb.pay_basis_id and
313: paf.person_id=ppf.person_id and
314: past.assignment_status_type_id = paf.assignment_status_type_id and

Line 325: per_assignment_status_types past1,

321: paf.person_id = p_person_id and
322: paf.assignment_id=pppv.assignment_id and
323: paf.effective_start_date = ( select max(effective_start_date)
324: from per_all_assignments_f paf1,
325: per_assignment_status_types past1,
326: hr_lookups hrl1
327: where paf1.business_group_id = p_business_group_id
328: and paf1.assignment_id = pppv.assignment_id
329: and paf1.person_id = p_person_id