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

Line 1468: , per_ass_status_type_amends_tl btl

1464: , nvl(btl.user_status,atl.user_status)
1465: , a.per_system_status
1466: from per_assignment_status_types_tl atl
1467: , per_assignment_status_types a
1468: , per_ass_status_type_amends_tl btl
1469: , per_ass_status_type_amends b
1470: where b.assignment_status_type_id(+) = a.assignment_status_type_id
1471: and b.business_group_id(+) + 0 = p_business_group_id
1472: and nvl(a.business_group_id,p_business_group_id) = p_business_group_id

Line 1469: , per_ass_status_type_amends b

1465: , a.per_system_status
1466: from per_assignment_status_types_tl atl
1467: , per_assignment_status_types a
1468: , per_ass_status_type_amends_tl btl
1469: , per_ass_status_type_amends b
1470: where b.assignment_status_type_id(+) = a.assignment_status_type_id
1471: and b.business_group_id(+) + 0 = p_business_group_id
1472: and nvl(a.business_group_id,p_business_group_id) = p_business_group_id
1473: and nvl(a.legislation_code,p_legislation_code) = p_legislation_code