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_RATE_PVT_PKG dependencies on PA_RESOURCES_DENORM

Line 360: FROM pa_resources_denorm

356: SELECT NVL(resource_org_id,-99),resource_organization_id,
357: job_id
358: INTO l_expenditure_org_id,l_expenditure_organization_id,
359: l_forecast_job_id
360: FROM pa_resources_denorm
361: WHERE person_id = p_person_id
362: AND ( p_rate_calc_date BETWEEN TRUNC(resource_effective_start_date) AND
363: NVL(TRUNC(Resource_effective_end_date),p_rate_calc_date));
364: EXCEPTION -- Added Exception block for Bug 3877942

Line 367: PA_DEBUG.g_err_stage := 'RTS12 : No Record in PA_RESOURCES_DENORM for this period start date' || p_rate_calc_date;

363: NVL(TRUNC(Resource_effective_end_date),p_rate_calc_date));
364: EXCEPTION -- Added Exception block for Bug 3877942
365: WHEN NO_DATA_FOUND THEN
366: IF g1_debug_mode = 'Y' THEN
367: PA_DEBUG.g_err_stage := 'RTS12 : No Record in PA_RESOURCES_DENORM for this period start date' || p_rate_calc_date;
368: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
369: END IF;
370: PA_DEBUG.Reset_Curr_Function;
371: RETURN;

Line 2247: FROM pa_resources_denorm

2243: END IF;
2244: ELSIF ( p_assignment_type = 'A') THEN
2245: SELECT job_id
2246: INTO l_forecast_job_id
2247: FROM pa_resources_denorm
2248: WHERE person_id = p_person_id
2249: AND ( p_asgn_start_date BETWEEN TRUNC(resource_effective_start_date) AND
2250: NVL(TRUNC(resource_effective_end_date),p_asgn_start_date));
2251: