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_FORECAST_ITEMS_GEN_WF_PKG dependencies on PA_RESOURCES_DENORM

Line 129: from pa_resources_denorm

125: BEGIN
126:
127: SELECT pa_expenditures_utils.GetOrgTlName(resource_organization_id)
128: INTO l_name
129: from pa_resources_denorm
130: WHERE resource_Id = p_resource_id
131: AND rownum = 1
132: AND ((trunc(p_start_date) BETWEEN
133: trunc(resource_effective_start_date) AND

Line 157: FROM pa_resources_denorm

153: BEGIN
154:
155: SELECT pa_expenditures_utils.GetOrgTlName(resource_organization_id)
156: INTO l_name
157: FROM pa_resources_denorm
158: WHERE resource_Id = p_resource_id
159: AND rownum = 1
160: AND trunc(p_start_date) BETWEEN trunc(resource_effective_start_date)
161: AND NVL(resource_effective_end_date,SYSDATE+1)