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

Line 964: , per_ass_status_type_amends b

960: --
961: CURSOR get_actve_apl IS
962: SELECT a.assignment_status_type_id
963: FROM per_assignment_status_types a
964: , per_ass_status_type_amends b
965: WHERE a.per_system_status = 'ACTIVE_APL'
966: AND b.assignment_status_type_id(+) = a.assignment_status_type_id
967: AND b.business_group_id(+) + 0 = p_business_group_id
968: AND nvl(a.business_group_id, p_business_group_id) =

Line 2451: per_ass_status_type_amends b

2447: -- Reverse termination)
2448: cursor csr_get_asg_status is
2449: select a.assignment_status_type_id
2450: from per_assignment_status_types a,
2451: per_ass_status_type_amends b
2452: where a.per_system_status = l_ass_status
2453: and b.assignment_status_type_id(+) = a.assignment_status_type_id
2454: and b.business_group_id(+) + 0 = p_business_group_id
2455: and nvl(a.business_group_id, p_business_group_id) =