APPS.PA_HR_UPDATE_API dependencies on PA_RESOURCE_TXN_ATTRIBUTES

Line 2176: v_resource_id Pa_Resource_txn_attributes.resource_id%type;

2172: v_error_message_code VARCHAR2(2000);
2173: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;
2174: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;
2175: v_Person_id Per_all_assignments_f.person_id%type;
2176: v_resource_id Pa_Resource_txn_attributes.resource_id%type;
2177: v_Default_OU Hr_Organization_Information.Org_Information1%type;
2178: v_msg_data VARCHAR2(2000);
2179: v_msg_count NUMBER;
2180:

Line 2201: , pa_resource_txn_attributes res

2197: FROM per_all_assignments_f assn
2198: , hr_organization_information hrinf
2199: /* , per_person_types pertypes Commented for bug#2781713 */
2200: , per_assignment_status_types pastype
2201: , pa_resource_txn_attributes res
2202: , pa_all_organizations allorgs
2203: , per_all_people_f pep
2204: WHERE
2205: assn.assignment_status_type_id = pastype.assignment_status_type_id

Line 2252: , pa_resource_txn_attributes res

2248: FROM per_all_assignments_f assn
2249: , hr_organization_information hrinf
2250: /* , per_person_types pertypes Commented for bug#2781713 */
2251: , per_assignment_status_types pastype
2252: , pa_resource_txn_attributes res
2253: , pa_all_organizations allorgs
2254: , per_all_people_f pep
2255: WHERE
2256: assn.assignment_status_type_id = pastype.assignment_status_type_id

Line 3131: -- person does not exist in pa_resource_txn_attributes

3127:
3128: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3129:
3130: ELSE
3131: -- person does not exist in pa_resource_txn_attributes
3132: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3133: END IF;
3134:
3135: -- reset the Error stack