DBA Data[Home] [Help]

APPS.PA_STAFFED_ASSIGNMENT_PVT dependencies on PA_RESOURCE_TXN_ATTRIBUTES

Line 86: FROM pa_resource_txn_attributes

82: l_future_term_wf_flag pa_resources.future_term_wf_flag%TYPE := NULL; -- Added for Bug 6056112
83:
84: CURSOR get_resource_source_id IS
85: SELECT person_id
86: FROM pa_resource_txn_attributes
87: WHERE resource_id = l_assignment_rec.resource_id;
88:
89: /* Created for bug 2381199 */
90: CURSOR get_system_status IS

Line 1299: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;

1295: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1296: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1297: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1298: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1299: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1300: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1301:
1302: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1303: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;

Line 1525: from pa_resource_txn_attributes

1521: -- check if mandatory attributes are changed
1522: IF l_assignment_rec.resource_id <> FND_API.G_MISS_NUM THEN
1523: select person_id
1524: into l_person_id
1525: from pa_resource_txn_attributes
1526: WHERE resource_id = l_assignment_rec.resource_id;
1527: END IF;
1528: IF P_DEBUG_MODE = 'Y' THEN
1529: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'