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_MASS_ASGMT_TRX dependencies on PA_PROJECT_ASSIGNMENTS_V

Line 1196: --FROM pa_project_assignments_v

1192:
1193: -- Commented for Perf fix 4918687 SQL ID 14910597
1194: --cursor csr_get_tp_amt_type (p_asg_id NUMBER) IS
1195: --SELECT fcst_tp_amount_type_name
1196: --FROM pa_project_assignments_v
1197: --WHERE assignment_id = p_asg_id;
1198:
1199: -- Added for Perf fix 4918687 SQL ID 14910597
1200: cursor csr_get_tp_amt_type (p_asg_id NUMBER) IS

Line 1252: l_tp_amt_type_name pa_project_assignments_v.fcst_tp_amount_type_name%TYPE;

1248: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;
1249: l_location_country_code pa_locations.country_code%TYPE;
1250: l_calendar_name jtf_calendars_tl.calendar_name%TYPE;
1251: l_work_type_name pa_work_types_vl.name%TYPE;
1252: l_tp_amt_type_name pa_project_assignments_v.fcst_tp_amount_type_name%TYPE;
1253: l_expense_owner pa_project_assignments.expense_owner%TYPE;
1254: l_expense_limit pa_project_assignments.expense_limit%TYPE;
1255: l_expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE;
1256: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;