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 14077: -- Query assignment_type in ('STAFFED_ASSIGNMENT','STAFFED_ADMIN_ASSIGNMENT') based on pa_resources_denorm.resource_organization_id

14073: WHERE proj_asgn.assignment_id = psch.assignment_id
14074: AND psch.forecast_txn_generated_flag = 'N')
14075: )
14076: UNION
14077: -- Query assignment_type in ('STAFFED_ASSIGNMENT','STAFFED_ADMIN_ASSIGNMENT') based on pa_resources_denorm.resource_organization_id
14078: SELECT proj_asgn.assignment_id,'ERROR'l_process_mode,
14079: proj_asgn.start_date,proj_asgn.end_date
14080: FROM pa_project_assignments proj_asgn,
14081: pa_resources_denorm prd

Line 14081: pa_resources_denorm prd

14077: -- Query assignment_type in ('STAFFED_ASSIGNMENT','STAFFED_ADMIN_ASSIGNMENT') based on pa_resources_denorm.resource_organization_id
14078: SELECT proj_asgn.assignment_id,'ERROR'l_process_mode,
14079: proj_asgn.start_date,proj_asgn.end_date
14080: FROM pa_project_assignments proj_asgn,
14081: pa_resources_denorm prd
14082: WHERE proj_asgn.template_flag = 'N'
14083: AND proj_asgn.assignment_type IN ('STAFFED_ASSIGNMENT','STAFFED_ADMIN_ASSIGNMENT')
14084: AND proj_asgn.resource_id = prd.resource_id
14085: AND prd.resource_organization_id = p_orgz_id

Line 14918: FROM pa_resources_denorm rou

14914: rou.resource_effective_start_date,
14915: NVL(rou.resource_effective_end_date,p_item_date)
14916: BULK COLLECT INTO
14917: l_BillableFlagTab,l_StartDateTab,l_EndDateTab
14918: FROM pa_resources_denorm rou
14919: WHERE rou.person_id= p_person_id
14920: ORDER BY rou.resource_effective_start_date;
14921:
14922: EXCEPTION

Line 15049: FROM pa_resources_denorm rou

15045: rou.resource_effective_start_date,
15046: NVL(rou.resource_effective_end_date,p_item_date)
15047: BULK COLLECT INTO
15048: l_UtilFlagTab,l_StartDateTab,l_EndDateTab
15049: FROM pa_resources_denorm rou
15050: WHERE rou.person_id= p_person_id
15051: ORDER BY rou.resource_effective_start_date;
15052:
15053: EXCEPTION