APPS.PA_MASS_ASGMT_TRX dependencies on FND_TERRITORIES_TL

Line 40: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

36: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
37: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
38: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
39: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
40: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
41: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
42: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
43: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
44: ,p_revenue_currency_code IN pa_project_assignments.revenue_currency_code%TYPE := FND_API.G_MISS_CHAR

Line 1305: l_location_country_name fnd_territories_tl.territory_short_name%TYPE;

1301: l_staffing_priority_name pa_lookups.meaning%TYPE;
1302: l_project_role_name pa_project_role_types.meaning%TYPE;
1303: l_location_city pa_locations.city%TYPE;
1304: l_location_region pa_locations.region%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;