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

Line 270: FROM per_all_assignments_f asg, per_assignment_status_types pss

266: ,asg.business_group_id business_group_id
267: ,DECODE(asg.business_group_id
268: ,g_business_group_id, 0
269: ,asg.business_group_id) bizgrpcol
270: FROM per_all_assignments_f asg, per_assignment_status_types pss
271: WHERE asg.person_id = p_person_id
272: AND asg.assignment_id <> p_primary_assignment_id
273: AND asg.assignment_type = 'E' --only employee assignments
274: AND pss.assignment_status_type_id = asg.assignment_status_type_id

Line 295: ,per_assignment_status_types pss

291: ,DECODE(asg.business_group_id
292: ,g_business_group_id, 0
293: ,asg.business_group_id) bizgrpcol
294: FROM per_all_people_f per, per_all_assignments_f asg
295: ,per_assignment_status_types pss
296: WHERE per.person_id <> p_person_id
297: AND ((p_effective_date BETWEEN per.effective_start_date
298: AND per.effective_end_date)
299: -- ENH3: Cross Person Reporting.