APPS.PA_FORECAST_ITEMS_UTILS dependencies on PA_RESOURCES

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;

Line 1200: pa_resources res

1196:
1197: SELECT typ.RESOURCE_TYPE_CODE
1198: INTO lv_resource_type
1199: FROM pa_resource_types typ,
1200: pa_resources res
1201: WHERE res.resource_type_id= typ.resource_type_id
1202: AND res.resource_id= p_resource_id;
1203:
1204: RETURN (lv_resource_type);