APPS.AMW_WF_HIERARCHY_PKG dependencies on WF_ACTIVITIES_TL

Line 1645: from wf_activities_tl watl, wf_activities wa, amw_process ap

1641: where party_id = p_process_owner_party_id;
1642:
1643: select watl.display_name
1644: into l_parent_disp_name
1645: from wf_activities_tl watl, wf_activities wa, amw_process ap
1646: where ap.process_id = p_parent_process_id
1647: and ap.name = wa.name
1648: and wa.item_type = 'AUDITMGR'
1649: and wa.end_date is null

Line 1657: from wf_activities_tl watl, wf_activities wa, amw_process ap

1653: and watl.language = userenv('LANG');
1654:
1655: select watl.display_name
1656: into l_child_disp_name
1657: from wf_activities_tl watl, wf_activities wa, amw_process ap
1658: where ap.process_id = p_child_process_id
1659: and ap.name = wa.name
1660: and wa.item_type = 'AUDITMGR'
1661: and wa.end_date is null