APPS.PA_FORECASTITEM_PVT dependencies on PA_RESOURCES_DENORM

Line 5194: from pa_resources_denorm

5190:
5191: cursor c_res_dates is
5192: select min(resource_effective_start_date),
5193: max(resource_effective_end_date)
5194: from pa_resources_denorm
5195: where resource_id = p_AsgnDtlRec.resource_id;
5196:
5197: ld_res_asgn_start_date DATE;
5198: ld_res_asgn_end_date DATE;

Line 9602: from pa_resources_denorm

9598:
9599: cursor c_res_dates is
9600: select min(resource_effective_start_date),
9601: max(resource_effective_end_date)
9602: from pa_resources_denorm
9603: where resource_id = p_resource_id;
9604:
9605: ld_res_start_date DATE;
9606: ld_res_end_date DATE;

Line 14863: FROM pa_resources_denorm rou

14859: rou.resource_effective_start_date,
14860: NVL(rou.resource_effective_end_date,p_item_date)
14861: BULK COLLECT INTO
14862: l_BillableFlagTab,l_StartDateTab,l_EndDateTab
14863: FROM pa_resources_denorm rou
14864: WHERE rou.person_id= p_person_id
14865: ORDER BY rou.resource_effective_start_date;
14866:
14867: EXCEPTION

Line 14994: FROM pa_resources_denorm rou

14990: rou.resource_effective_start_date,
14991: NVL(rou.resource_effective_end_date,p_item_date)
14992: BULK COLLECT INTO
14993: l_UtilFlagTab,l_StartDateTab,l_EndDateTab
14994: FROM pa_resources_denorm rou
14995: WHERE rou.person_id= p_person_id
14996: ORDER BY rou.resource_effective_start_date;
14997:
14998: EXCEPTION