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_ASSIGNMENT_APPROVAL_PUB dependencies on PA_WORK_TYPES_VL

Line 1178: l_new_work_type pa_work_types_vl.name%TYPE;

1174: l_new_country_code pa_locations.country_code%TYPE;
1175: l_old_city pa_locations.city%TYPE;
1176: l_old_region pa_locations.region%TYPE;
1177: l_old_country_code pa_locations.country_code%TYPE;
1178: l_new_work_type pa_work_types_vl.name%TYPE;
1179: l_old_work_type pa_work_types_vl.name%TYPE;
1180: l_new_subteam_name pa_project_subteams.name%TYPE;
1181: l_old_subteam_name pa_project_subteams.name%TYPE;
1182: l_project_subteam_id pa_project_subteam_parties.project_subteam_id%TYPE;

Line 1179: l_old_work_type pa_work_types_vl.name%TYPE;

1175: l_old_city pa_locations.city%TYPE;
1176: l_old_region pa_locations.region%TYPE;
1177: l_old_country_code pa_locations.country_code%TYPE;
1178: l_new_work_type pa_work_types_vl.name%TYPE;
1179: l_old_work_type pa_work_types_vl.name%TYPE;
1180: l_new_subteam_name pa_project_subteams.name%TYPE;
1181: l_old_subteam_name pa_project_subteams.name%TYPE;
1182: l_project_subteam_id pa_project_subteam_parties.project_subteam_id%TYPE;
1183: l_his_project_subteam_id pa_assignments_history.project_subteam_id%TYPE;

Line 1224: FROM pa_work_types_vl

1220: AND last_approved_flag = 'Y';
1221:
1222: CURSOR get_work_type_names (new_work_type_id NUMBER, old_work_type_id NUMBER) IS
1223: SELECT work_type_id, name
1224: FROM pa_work_types_vl
1225: WHERE work_type_id in (new_work_type_id, old_work_type_id);
1226:
1227: BEGIN
1228: --Issue rollback to clean up the Global Temporary Table PA_ASGMT_CHANGED_ITEMS

Line 2470: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

2466: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
2467: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2468: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2469: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2470: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2471: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2472: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2473: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2474: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR