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 364: per_assignment_status_types past,

360: from per_pay_bases ppb,
361: per_all_assignments_f paf,
362: per_all_people_f ppf,
363: per_pay_proposals_v2 pppv,
364: per_assignment_status_types past,
365: hr_lookups hrl
366: where paf.pay_basis_id = ppb.pay_basis_id and
367: paf.person_id=ppf.person_id and
368: past.assignment_status_type_id = paf.assignment_status_type_id and

Line 380: per_assignment_status_types past1,

376: paf.assignment_id=pppv.assignment_id and
377: pppv.approved = 'Y' and -- to calculate only approved salaries
378: paf.effective_start_date = ( select max(effective_start_date)
379: from per_all_assignments_f paf1,
380: per_assignment_status_types past1,
381: hr_lookups hrl1
382: where paf1.business_group_id = p_business_group_id
383: and paf1.assignment_id = pppv.assignment_id
384: and paf1.person_id = p_person_id