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.PA_IMPL_OPTIONS_PUB dependencies on PA_PROJECTS_ALL

Line 104: FROM pa_projects_all

100: ) RETURN VARCHAR2 IS
101: CURSOR cur_pa_proj
102: IS
103: SELECT include_gains_losses_flag
104: FROM pa_projects_all
105: WHERE org_id = p_org_id -- 5078716 , Removed nvl condition
106: AND project_type = p_project_type
107: AND include_gains_losses_flag = 'Y';
108:

Line 223: from pa_projects_all

219: ) is
220:
221: cursor c_projects is
222: select project_id
223: from pa_projects_all
224: where segment1 >= nvl(p_from_project_number, segment1)
225: and segment1 <= nvl(p_to_project_number, segment1)
226: and project_status_code = nvl(p_project_status, project_status_code)
227: and project_type = nvl(p_project_type, project_type)

Line 246: update pa_projects_all

242: IF p_access_level is not null THEN
243:
244: for rec in c_projects loop
245:
246: update pa_projects_all
247: set security_level = to_number( p_access_level),
248: last_update_date = l_last_update_date,
249: last_updated_by = l_last_updated_by,
250: last_update_login = l_last_update_login