APPS.PA_FORECAST_ITEMS_UTILS dependencies on PA_RESOURCES_DENORM

Line 870: FROM pa_resources_denorm rou

866: rou.resource_effective_start_date,
867: NVL(rou.resource_effective_end_date,SYSDATE)
868: BULK COLLECT INTO
869: x_ResourceOUTab,x_StartDateTab,x_EndDateTab
870: FROM pa_resources_denorm rou
871: WHERE rou.resource_id= p_resource_id
872: AND ld_start_date <= NVL(rou.resource_effective_end_date,SYSDATE)
873: AND ld_end_date >= rou.resource_effective_start_date
874: ORDER BY rou.resource_effective_start_date;

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

1032: --- | also added new date criteria since
1033: --- | per_people_f could contain multiple records
1034: --- | per resource.
1035:
1036: --- Modified select statements to select directly off of pa_resources_denorm
1037: --- This is for better performance and it is safer.
1038:
1039: BEGIN
1040: --Bug 4207110 :Added equalto condition while performing date check

Line 1051: from pa_resources_denorm rou

1047: x_ResourceOrganizationIDTab,
1048: x_StartDateTab,
1049: x_EndDateTab,
1050: x_ResourceJobIDTab
1051: from pa_resources_denorm rou
1052: where person_id = p_person_id
1053: AND ld_start_date <= NVL(rou.resource_effective_end_date,SYSDATE)
1054: AND ld_end_date >= rou.resource_effective_start_date
1055: ORDER BY rou.resource_effective_start_date;