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

Line 252: per_ass_status_type_amends_tl atl,

248: SELECT
249: nvl(atl.user_status ,stl.user_status),
250: nvl(a.per_system_status ,s.per_system_status)
251: FROM
252: per_ass_status_type_amends_tl atl,
253: per_ass_status_type_amends a,
254: per_assignment_status_types_tl stl,
255: per_assignment_status_types s
256: WHERE

Line 253: per_ass_status_type_amends a,

249: nvl(atl.user_status ,stl.user_status),
250: nvl(a.per_system_status ,s.per_system_status)
251: FROM
252: per_ass_status_type_amends_tl atl,
253: per_ass_status_type_amends a,
254: per_assignment_status_types_tl stl,
255: per_assignment_status_types s
256: WHERE
257: s.assignment_status_type_id=p_assignment_status_type_id and

Line 700: ,'per_assignment_status_types s_a,per_assignment_status_types_tl stl_a,per_ass_status_type_amends a_a,per_ass_status_type_amends_tl atl_a'

696: --Modified for PMxbg
697: l_a_where_clause:=build_varchar2_where('per_asg.assignment_status_type_id'
698: ,p_condition
699: ,p_value
700: ,'per_assignment_status_types s_a,per_assignment_status_types_tl stl_a,per_ass_status_type_amends a_a,per_ass_status_type_amends_tl atl_a'
701: ,'s_a.assignment_status_type_id'
702: ,'nvl(atl_a.user_status,stl_a.user_status)'
703: ,' and a_a.assignment_status_type_id (+)=s_a.assignment_status_type_id'
704: ||' and s_a.assignment_status_type_id=stl_a.assignment_status_type_id'

Line 1089: l_from_clause:=l_from_clause||',per_ass_status_type_amends a,per_ass_status_type_amends_tl atl';

1085: l_where_clause:=l_where_clause||' and per_asg.assignment_status_type_id='||assignment_status_type_id;
1086: l_asg:=TRUE;
1087: elsif assignment_status_type is not null then
1088: l_from_clause:=l_from_clause||',per_assignment_status_types s,per_assignment_status_types_tl stl';
1089: l_from_clause:=l_from_clause||',per_ass_status_type_amends a,per_ass_status_type_amends_tl atl';
1090: l_where_clause:=l_where_clause||' and upper(nvl(atl.user_status,stl.user_status))'
1091: ||' like ('''||upper(replace(assignment_status_type,g_quote,g_quote||g_quote))||''')'
1092: ||' and s.assignment_status_type_id=per_asg.assignment_status_type_id'
1093: ||' and a.assignment_status_type_id (+)=s.assignment_status_type_id'