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 3556: and asg.assignment_status_type_id in (select assignment_status_type_id from PER_ASS_STATUS_TYPE_AMENDS

3552: cursor c_get_all_assignmentid(c_person_id in number) IS
3553: select assignment_id
3554: from per_all_assignments_f asg
3555: where asg.person_id = c_person_id
3556: and asg.assignment_status_type_id in (select assignment_status_type_id from PER_ASS_STATUS_TYPE_AMENDS
3557: where business_group_id = p_business_group_id and pay_system_status = 'P' and active_flag = 'Y'
3558: union
3559: select assignment_status_type_id from per_assignment_status_types typ
3560: where typ.pay_system_status = 'P'