APPS.PA_MASS_ASGMT_TRX dependencies on PA_PROJECT_ASSIGNMENTS_V

Line 1253: --FROM pa_project_assignments_v

1249:
1250: -- Commented for Perf fix 4918687 SQL ID 14910597
1251: --cursor csr_get_tp_amt_type (p_asg_id NUMBER) IS
1252: --SELECT fcst_tp_amount_type_name
1253: --FROM pa_project_assignments_v
1254: --WHERE assignment_id = p_asg_id;
1255:
1256: -- Added for Perf fix 4918687 SQL ID 14910597
1257: cursor csr_get_tp_amt_type (p_asg_id NUMBER) IS

Line 1309: l_tp_amt_type_name pa_project_assignments_v.fcst_tp_amount_type_name%TYPE;

1305: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;
1306: l_location_country_code pa_locations.country_code%TYPE;
1307: l_calendar_name jtf_calendars_tl.calendar_name%TYPE;
1308: l_work_type_name pa_work_types_vl.name%TYPE;
1309: l_tp_amt_type_name pa_project_assignments_v.fcst_tp_amount_type_name%TYPE;
1310: l_expense_owner pa_project_assignments.expense_owner%TYPE;
1311: l_expense_limit pa_project_assignments.expense_limit%TYPE;
1312: l_expense_limit_currency_code pa_project_assignments.expense_limit_currency_code%TYPE;
1313: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;