APPS.PA_MASS_ASGMT_TRX dependencies on FND_TERRITORIES_VL

Line 61: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

57: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
58: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
59: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
60: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
61: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
62: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
63: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
64: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
65: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR

Line 1261: l_search_country_name fnd_territories_vl.territory_short_name%TYPE;

1257: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;
1258: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
1259: l_search_min_availability pa_project_assignments.search_min_availability%TYPE;
1260: l_search_country_code pa_project_assignments.search_country_code%TYPE;
1261: l_search_country_name fnd_territories_vl.territory_short_name%TYPE;
1262: l_search_exp_org_struct_ver_id pa_project_assignments.search_exp_org_struct_ver_id%TYPE;
1263: l_search_exp_org_hier_name per_organization_structures.name%TYPE;
1264: l_search_exp_start_org_id pa_project_assignments.search_exp_start_org_id%TYPE;
1265: l_search_exp_start_org_name hr_organization_units.name%TYPE;