eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_EMPLOYEE_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 794: FROM per_all_assignments_f

790: p_hire_date);
791:
792: SELECT object_version_number
793: INTO l_asg_object_Version_number
794: FROM per_all_assignments_f
795: WHERE business_group_id = p_business_group_id
796: and person_id = l_person_id
797: and assignment_id = l_assignment_id
798: and effective_start_Date = p_hire_date;

Line 3717: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

3713: --
3714: -- Local variables
3715: --
3716: l_proc VARCHAR2(72) := g_package||'hire_into_job';
3717: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3718: --
3719: BEGIN
3720: --
3721: if g_debug then

Line 3777: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;

3773: l_proc VARCHAR2(72) := g_package||'hire_into_job';
3774: --
3775: l_effective_date DATE;
3776: --
3777: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
3778: l_datetrack_update_mode VARCHAR2(30) := p_datetrack_update_mode;
3779: l_employee_number CONSTANT per_all_people_f.applicant_number%TYPE := p_employee_number;
3780: l_emp_num per_all_people_f.applicant_number%TYPE := p_employee_number;
3781: l_ovn per_all_people_f.object_version_number%TYPE := p_object_version_number;

Line 3802: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

3798: l_full_name per_all_people_f.full_name%TYPE;
3799: l_name_combination_warning BOOLEAN;
3800: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
3801: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
3802: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3803: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
3804: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3805: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3806: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;

Line 3803: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

3799: l_name_combination_warning BOOLEAN;
3800: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
3801: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
3802: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3803: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
3804: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3805: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3806: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
3807: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;

Line 3804: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

3800: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
3801: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
3802: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3803: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
3804: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3805: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3806: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
3807: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;
3808: --

Line 3805: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

3801: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
3802: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3803: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
3804: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3805: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3806: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
3807: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;
3808: --
3809: -- Start of fix for bug 3143299

Line 4641: INSERT INTO per_all_assignments_f

4637: --
4638: -- Insert new record with primary flag 'N' and ESD
4639: -- same as EED same as rehire date
4640: --
4641: INSERT INTO per_all_assignments_f
4642: (assignment_id
4643: ,effective_start_date
4644: ,effective_end_date
4645: ,business_group_id

Line 4892: INSERT INTO per_all_assignments_f

4888: --
4889: -- Insert new record primary flag 'N' and ESD
4890: -- same as rehire date
4891: --
4892: INSERT INTO per_all_assignments_f
4893: (assignment_id
4894: ,effective_start_date
4895: ,effective_end_date
4896: ,business_group_id