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_ASSIGNMENT dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 1177: FROM PER_SPINAL_POINT_PLACEMENTS_F P

1173: into del_flag
1174: FROM SYS.DUAL
1175: WHERE EXISTS
1176: (SELECT NULL
1177: FROM PER_SPINAL_POINT_PLACEMENTS_F P
1178: WHERE P.business_group_id + 0 = p_business_group_id
1179: AND P.ASSIGNMENT_ID = p_assignment_id);
1180: --
1181: EXCEPTION

Line 1188: DELETE FROM PER_SPINAL_POINT_PLACEMENTS_F P

1184: --
1185: IF del_flag = 'Y' THEN
1186: hr_utility.set_location('hr_assignment.delete_ass_ref_int',2);
1187: --
1188: DELETE FROM PER_SPINAL_POINT_PLACEMENTS_F P
1189: WHERE P.business_group_id + 0 = p_business_group_id
1190: AND P.ASSIGNMENT_ID = p_assignment_id;
1191: --
1192: END IF;

Line 2863: PER_SPINAL_POINT_PLACEMENTS_F

2859:
2860: For 'ZAP'
2861: HR_ASSIGNMENT_SET_AMENDMENTS
2862: PER_ASSIGNMENT_BUDGET_VALUES_F
2863: PER_SPINAL_POINT_PLACEMENTS_F
2864: PER_PAY_PROPOSALS
2865:
2866: For 'END' (performs a date effective delete)
2867: PER_SPINAL_POINT_PLACEMENTS_F

Line 2867: PER_SPINAL_POINT_PLACEMENTS_F

2863: PER_SPINAL_POINT_PLACEMENTS_F
2864: PER_PAY_PROPOSALS
2865:
2866: For 'END' (performs a date effective delete)
2867: PER_SPINAL_POINT_PLACEMENTS_F
2868: PER_ASSIGNMENT_BUDGET_VALUES_F
2869:
2870: For 'FUTURE' (including FUTURE_CHANGES, DELETE_NEXT_CHANGE,
2871: UPDATE_OVERRIDE)

Line 2872: PER_SPINAL_POINT_PLACEMENTS_F

2868: PER_ASSIGNMENT_BUDGET_VALUES_F
2869:
2870: For 'FUTURE' (including FUTURE_CHANGES, DELETE_NEXT_CHANGE,
2871: UPDATE_OVERRIDE)
2872: PER_SPINAL_POINT_PLACEMENTS_F
2873: PER_ASSIGNMENT_BUDGET_VALUES_F
2874:
2875: PARAMETERS
2876: p_assignment_id - The current assignment

Line 2930: from per_spinal_point_placements_f spp

2926: -- Check to see if a grade step has been created for assignment
2927: --
2928: cursor csr_grade_step is
2929: select spp.placement_id
2930: from per_spinal_point_placements_f spp
2931: where spp.assignment_id = p_assignment_id
2932: and p_val_st_date between spp.effective_start_date
2933: and spp.effective_end_date;
2934: --

Line 2939: from per_spinal_point_placements_f spp1

2935: -- Checks to see if future rows exist - Datetrack mode
2936: --
2937: cursor csr_future_records is
2938: select spp1.placement_id
2939: from per_spinal_point_placements_f spp1
2940: where spp1.assignment_id = p_assignment_id
2941: and spp1.effective_start_date > p_val_st_date;
2942: --
2943: -- Check to see if future records are for current parent spine

Line 2948: from per_spinal_point_placements_f spp2

2944: -- If so flag a warning!
2945: --
2946: cursor csr_record_check is
2947: select spp2.placement_id
2948: from per_spinal_point_placements_f spp2
2949: where spp2.assignment_id = p_assignment_id
2950: and spp2.effective_start_date > p_val_st_date
2951: and spp2.parent_spine_id = l_old_parent_spine_id
2952: and spp2.effective_end_date <= p_val_end_date;

Line 2961: from per_spinal_point_placements_f spp

2957: cursor csr_spp_rec(p_new_date date) is
2958: select spp.effective_end_date,
2959: spp.placement_id,
2960: spp.object_version_number
2961: from per_spinal_point_placements_f spp
2962: where spp.assignment_id = p_assignment_id
2963: and p_new_date between spp.effective_start_date
2964: and spp.effective_end_date;
2965: --

Line 2970: from per_spinal_point_placements_f spp

2966: -- Cursor to retrive the SPP effective_end_date
2967: --
2968: cursor csr_spp_end_date(p_placement_id number, l_edate date) is
2969: select spp.effective_end_date
2970: from per_spinal_point_placements_f spp
2971: where spp.placement_id = p_placement_id
2972: and l_edate between spp.effective_start_date
2973: and spp.effective_end_date;
2974: -- End of 3280773

Line 2991: FROM PER_SPINAL_POINT_PLACEMENTS_F P

2987: into p_del_flag
2988: FROM SYS.DUAL
2989: WHERE EXISTS
2990: (SELECT NULL
2991: FROM PER_SPINAL_POINT_PLACEMENTS_F P
2992: WHERE P.ASSIGNMENT_ID = p_assignment_id
2993: AND (p_mode = 'ZAP'
2994: OR (p_mode = 'END'
2995: AND EFFECTIVE_END_DATE > p_end_date)

Line 3022: from per_spinal_point_placements_f

3018: -- Get the min start date for the placement
3019: --
3020: select min(effective_start_date)
3021: into l_min_start_date
3022: from per_spinal_point_placements_f
3023: where assignment_id = p_assignment_id;
3024:
3025: if l_min_start_date = p_val_st_date
3026: and p_datetrack_mode = 'DELETE_NEXT_CHANGE' then

Line 3069: /* DELETE FROM PER_SPINAL_POINT_PLACEMENTS_F P

3065:
3066: --
3067: -- Removed dml and inserted call to api
3068: --
3069: /* DELETE FROM PER_SPINAL_POINT_PLACEMENTS_F P
3070: WHERE P.ASSIGNMENT_ID = p_assignment_id;
3071: */
3072: --
3073: ELSIF p_mode = 'FUTURE' THEN

Line 3099: from per_spinal_point_placements_f spp

3095: -- the current record as of the effective date
3096: --
3097: select spp.placement_id,spp.object_version_number,spp.effective_start_date,spp.parent_spine_id
3098: into l_placement_id,l_object_version_number,l_date_temp,l_old_parent_spine_id
3099: from per_spinal_point_placements_f spp
3100: where spp.assignment_id = p_assignment_id
3101: and p_val_st_date between spp.effective_start_date
3102: and spp.effective_end_date;
3103:

Line 3261: DELETE FROM PER_SPINAL_POINT_PLACEMENTS_F P

3257: --
3258: -- Removed dml and inserted call to api
3259: --
3260: /*
3261: DELETE FROM PER_SPINAL_POINT_PLACEMENTS_F P
3262: WHERE P.ASSIGNMENT_ID = p_assignment_id
3263: AND P.EFFECTIVE_START_DATE >= p_end_date
3264: AND NOT EXISTS
3265: (SELECT NULL

Line 3282: DELETE FROM PER_SPINAL_POINT_PLACEMENTS_F P

3278: --
3279: -- Removed dml and using api
3280: --
3281: /*
3282: DELETE FROM PER_SPINAL_POINT_PLACEMENTS_F P
3283: WHERE P.ASSIGNMENT_ID = p_assignment_id
3284: AND P.EFFECTIVE_START_DATE > p_end_date;
3285: */
3286:

Line 3296: from per_spinal_point_placements_f spp

3292: if csr_grade_step%found then
3293:
3294: select spp.placement_id,spp.object_version_number,spp.effective_start_date
3295: into l_placement_id,l_object_version_number,l_date_temp
3296: from per_spinal_point_placements_f spp
3297: where spp.assignment_id = p_assignment_id
3298: and p_end_date between spp.effective_start_date
3299: and spp.effective_end_date;
3300:

Line 3319: UPDATE PER_SPINAL_POINT_PLACEMENTS_F

3315: close csr_grade_step;
3316:
3317:
3318: /*hr_utility.set_location('hr_assignment.delete_ass_ref_int',5);
3319: UPDATE PER_SPINAL_POINT_PLACEMENTS_F
3320: SET EFFECTIVE_END_DATE = p_end_date
3321: , LAST_UPDATED_BY = p_last_updated_by
3322: , LAST_UPDATE_LOGIN = p_last_update_login
3323: , LAST_UPDATE_DATE = sysdate