APPS.PA_ADVERTISEMENTS_PVT dependencies on PA_PROJECT_ROLE_TYPES

Line 1005: , p_project_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM

1001: , p_action_code IN pa_action_set_lines.action_code%TYPE
1002: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
1003: , p_method IN VARCHAR2
1004: , p_person_id IN pa_resources_denorm.person_id%TYPE := FND_API.G_MISS_NUM
1005: , p_project_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM
1006: , p_project_id IN pa_project_assignments.project_id%TYPE
1007: , p_insert_audit_flag IN VARCHAR2 := 'T'
1008: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1009: --, x_msg_count OUT NUMBER

Line 1226: l_project_role_name pa_project_role_types.meaning%TYPE;

1222: l_assignment_name pa_project_assignments.assignment_name%TYPE;
1223: l_start_date pa_project_assignments.start_date%TYPE;
1224: l_end_date pa_project_assignments.end_date%TYPE;
1225: l_project_organization_name hr_organization_units.name%TYPE;
1226: l_project_role_name pa_project_role_types.meaning%TYPE;
1227: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
1228: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
1229: l_staffing_priority_name VARCHAR2(80);
1230: l_description pa_project_assignments.description%TYPE;

Line 1296: pa_project_role_types prt,

1292: asgn.transfer_price_rate, -- Added for bug 3051110
1293: asgn.transfer_pr_rate_curr
1294: FROM pa_project_assignments asgn,
1295: pa_projects_all proj,
1296: pa_project_role_types prt,
1297: pa_lookups sp,
1298: pa_lookups fcst,
1299: pa_work_types_v wt
1300: WHERE assignment_id = p_assignment_id