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.PSP_ORG_DLS_PKG dependencies on PSP_REPORT_TEMPLATE_DETAILS

Line 73: from psp_report_template_details

69:
70:
71: cursor Org_count is
72: select count(1)
73: from psp_report_template_details
74: Where template_id = p_template_id
75: and CRITERIA_LOOKUP_TYPE = 'PSP_SELECTION_CRITERIA'
76: and CRITERIA_LOOKUP_CODE = 'ORG';
77:

Line 123: from psp_report_template_details

119:
120: If l_org_count<> 0 then
121:
122: g_organization_str := ' a.Organization_id in (select to_number(criteria_value1)
123: from psp_report_template_details
124: where template_id = '|| p_template_id || '
125: and CRITERIA_LOOKUP_TYPE = ''PSP_SELECTION_CRITERIA''
126: and CRITERIA_LOOKUP_CODE = ''ORG'' ) ' ;
127: