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_PENSION_FUNCTIONS dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 3653: and asg.assignment_status_type_id in (select assignment_status_type_id from PER_ASS_STATUS_TYPE_AMENDS

3649: cursor c_get_all_assignmentid(c_person_id in number) IS
3650: select assignment_id
3651: from per_all_assignments_f asg
3652: where asg.person_id = c_person_id
3653: and asg.assignment_status_type_id in (select assignment_status_type_id from PER_ASS_STATUS_TYPE_AMENDS
3654: where business_group_id = p_business_group_id and pay_system_status = 'P' and active_flag = 'Y'
3655: union
3656: select assignment_status_type_id from per_assignment_status_types typ
3657: where typ.pay_system_status = 'P'