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.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 1839: per_ass_status_type_amends a ,

1835: --
1836: cursor c_get_mapping_name1(p_id in number) is
1837: select nvl(atl.user_status, stl.user_status) dsp_meaning
1838: from per_assignment_status_types s,
1839: per_ass_status_type_amends a ,
1840: per_business_groups bus ,
1841: per_assignment_status_types_tl stl ,
1842: per_ass_status_type_amends_tl atl
1843: where a.assignment_status_type_id (+) = s.assignment_status_type_id

Line 1842: per_ass_status_type_amends_tl atl

1838: from per_assignment_status_types s,
1839: per_ass_status_type_amends a ,
1840: per_business_groups bus ,
1841: per_assignment_status_types_tl stl ,
1842: per_ass_status_type_amends_tl atl
1843: where a.assignment_status_type_id (+) = s.assignment_status_type_id
1844: and a.business_group_id (+) = p_business_group_id
1845: and nvl(s.business_group_id, p_business_group_id) = p_business_group_id
1846: and nvl(s.legislation_code, bus.legislation_code) = bus.legislation_code