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_UTILS dependencies on PA_RESOURCES

Line 863: FROM pa_resources_denorm rou

859: rou.resource_effective_start_date,
860: NVL(rou.resource_effective_end_date,SYSDATE)
861: BULK COLLECT INTO
862: x_ResourceOUTab,x_StartDateTab,x_EndDateTab
863: FROM pa_resources_denorm rou
864: WHERE rou.resource_id= p_resource_id
865: AND ld_start_date <= NVL(rou.resource_effective_end_date,SYSDATE)
866: AND ld_end_date >= rou.resource_effective_start_date
867: ORDER BY rou.resource_effective_start_date;

Line 1029: --- Modified select statements to select directly off of pa_resources_denorm

1025: --- | also added new date criteria since
1026: --- | per_people_f could contain multiple records
1027: --- | per resource.
1028:
1029: --- Modified select statements to select directly off of pa_resources_denorm
1030: --- This is for better performance and it is safer.
1031:
1032: BEGIN
1033: --Bug 4207110 :Added equalto condition while performing date check

Line 1044: from pa_resources_denorm rou

1040: x_ResourceOrganizationIDTab,
1041: x_StartDateTab,
1042: x_EndDateTab,
1043: x_ResourceJobIDTab
1044: from pa_resources_denorm rou
1045: where person_id = p_person_id
1046: AND ld_start_date <= NVL(rou.resource_effective_end_date,SYSDATE)
1047: AND ld_end_date >= rou.resource_effective_start_date
1048: ORDER BY rou.resource_effective_start_date;

Line 1193: pa_resources res

1189:
1190: SELECT typ.RESOURCE_TYPE_CODE
1191: INTO lv_resource_type
1192: FROM pa_resource_types typ,
1193: pa_resources res
1194: WHERE res.resource_type_id= typ.resource_type_id
1195: AND res.resource_id= p_resource_id;
1196:
1197: RETURN (lv_resource_type);