APPS.PA_ASSIGNMENTS_PUB dependencies on PA_RESOURCE_TXN_ATTRIBUTES

Line 996: FROM pa_resource_txn_attributes

992: WHERE team_template_id = l_assignment_rec.assignment_template_id;
993:
994: CURSOR get_resource_source_id IS
995: SELECT person_id
996: FROM pa_resource_txn_attributes
997: WHERE resource_id = l_assignment_rec.resource_id;
998:
999: BEGIN
1000:

Line 2192: pa_resource_txn_attributes rta

2188: -- get rlm of the new staffed assignment
2189: CURSOR get_staffed_asgmt_rlm(c_assignment_id NUMBER) IS
2190: SELECT pa.resource_list_member_id, rta.person_id
2191: FROM pa_project_assignments pa,
2192: pa_resource_txn_attributes rta
2193: WHERE pa.assignment_id = c_assignment_id
2194: AND pa.resource_id = rta.resource_id;
2195:
2196: CURSOR get_linked_res_asgmts IS

Line 2332: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;

2328: l_record_version_number NUMBER;
2329:
2330: l_new_rlm_id pa_project_assignments.resource_list_member_id%TYPE;
2331: l_old_rlm_id pa_project_assignments.resource_list_member_id%TYPE;
2332: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
2333: l_rlm_id pa_project_assignments.resource_list_member_id%TYPE;
2334:
2335: l_candidate_in_rec PA_RES_MANAGEMENT_AMG_PUB.CANDIDATE_IN_REC_TYPE; -- Added for bug 9187892
2336: