DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on PA_RESOURCE_TXN_ATTRIBUTES

Line 961: FROM pa_resource_txn_attributes

957: WHERE team_template_id = l_assignment_rec.assignment_template_id;
958:
959: CURSOR get_resource_source_id IS
960: SELECT person_id
961: FROM pa_resource_txn_attributes
962: WHERE resource_id = l_assignment_rec.resource_id;
963:
964: BEGIN
965:

Line 2129: pa_resource_txn_attributes rta

2125: -- get rlm of the new staffed assignment
2126: CURSOR get_staffed_asgmt_rlm(c_assignment_id NUMBER) IS
2127: SELECT pa.resource_list_member_id, rta.person_id
2128: FROM pa_project_assignments pa,
2129: pa_resource_txn_attributes rta
2130: WHERE pa.assignment_id = c_assignment_id
2131: AND pa.resource_id = rta.resource_id;
2132:
2133: CURSOR get_linked_res_asgmts IS

Line 2269: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;

2265: l_record_version_number NUMBER;
2266:
2267: l_new_rlm_id pa_project_assignments.resource_list_member_id%TYPE;
2268: l_old_rlm_id pa_project_assignments.resource_list_member_id%TYPE;
2269: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
2270: l_rlm_id pa_project_assignments.resource_list_member_id%TYPE;
2271:
2272: BEGIN
2273: