APPS.PA_HR_UPDATE_API dependencies on PA_RESOURCE_TXN_ATTRIBUTES

Line 2183: v_resource_id Pa_Resource_txn_attributes.resource_id%type;

2179: v_error_message_code VARCHAR2(2000);
2180: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;
2181: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;
2182: v_Person_id Per_all_assignments_f.person_id%type;
2183: v_resource_id Pa_Resource_txn_attributes.resource_id%type;
2184: v_Default_OU Hr_Organization_Information.Org_Information1%type;
2185: v_msg_data VARCHAR2(2000);
2186: v_msg_count NUMBER;
2187:

Line 2208: , pa_resource_txn_attributes res

2204: FROM per_all_assignments_f assn
2205: , hr_organization_information hrinf
2206: /* , per_person_types pertypes Commented for bug#2781713 */
2207: , per_assignment_status_types pastype
2208: , pa_resource_txn_attributes res
2209: , pa_all_organizations allorgs
2210: , per_all_people_f pep
2211: WHERE
2212: assn.assignment_status_type_id = pastype.assignment_status_type_id

Line 2259: , pa_resource_txn_attributes res

2255: FROM per_all_assignments_f assn
2256: , hr_organization_information hrinf
2257: /* , per_person_types pertypes Commented for bug#2781713 */
2258: , per_assignment_status_types pastype
2259: , pa_resource_txn_attributes res
2260: , pa_all_organizations allorgs
2261: , per_all_people_f pep
2262: WHERE
2263: assn.assignment_status_type_id = pastype.assignment_status_type_id

Line 3157: -- person does not exist in pa_resource_txn_attributes

3153:
3154: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3155:
3156: ELSE
3157: -- person does not exist in pa_resource_txn_attributes
3158: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3159: END IF;
3160:
3161: -- reset the Error stack