DBA Data[Home] [Help]

APPS.PA_MASS_ASGMT_TRX dependencies on PER_ORGANIZATION_STRUCTURES

Line 63: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR

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
66: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
67: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR

Line 1263: l_search_exp_org_hier_name per_organization_structures.name%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;
1266: l_search_min_candidate_score pa_project_assignments.search_min_candidate_score%TYPE;
1267: l_enable_auto_cand_nom_flag pa_project_assignments.enable_auto_cand_nom_flag%TYPE;