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 1147: FROM PER_SPINAL_POINT_PLACEMENTS_F P

1143: into del_flag
1144: FROM SYS.DUAL
1145: WHERE EXISTS
1146: (SELECT NULL
1147: FROM PER_SPINAL_POINT_PLACEMENTS_F P
1148: WHERE P.business_group_id + 0 = p_business_group_id
1149: AND P.ASSIGNMENT_ID = p_assignment_id);
1150: --
1151: EXCEPTION

Line 1158: DELETE FROM PER_SPINAL_POINT_PLACEMENTS_F P

1154: --
1155: IF del_flag = 'Y' THEN
1156: hr_utility.set_location('hr_assignment.delete_ass_ref_int',2);
1157: --
1158: DELETE FROM PER_SPINAL_POINT_PLACEMENTS_F P
1159: WHERE P.business_group_id + 0 = p_business_group_id
1160: AND P.ASSIGNMENT_ID = p_assignment_id;
1161: --
1162: END IF;

Line 2826: PER_SPINAL_POINT_PLACEMENTS_F

2822:
2823: For 'ZAP'
2824: HR_ASSIGNMENT_SET_AMENDMENTS
2825: PER_ASSIGNMENT_BUDGET_VALUES_F
2826: PER_SPINAL_POINT_PLACEMENTS_F
2827: PER_PAY_PROPOSALS
2828:
2829: For 'END' (performs a date effective delete)
2830: PER_SPINAL_POINT_PLACEMENTS_F

Line 2830: PER_SPINAL_POINT_PLACEMENTS_F

2826: PER_SPINAL_POINT_PLACEMENTS_F
2827: PER_PAY_PROPOSALS
2828:
2829: For 'END' (performs a date effective delete)
2830: PER_SPINAL_POINT_PLACEMENTS_F
2831: PER_ASSIGNMENT_BUDGET_VALUES_F
2832:
2833: For 'FUTURE' (including FUTURE_CHANGES, DELETE_NEXT_CHANGE,
2834: UPDATE_OVERRIDE)

Line 2835: PER_SPINAL_POINT_PLACEMENTS_F

2831: PER_ASSIGNMENT_BUDGET_VALUES_F
2832:
2833: For 'FUTURE' (including FUTURE_CHANGES, DELETE_NEXT_CHANGE,
2834: UPDATE_OVERRIDE)
2835: PER_SPINAL_POINT_PLACEMENTS_F
2836: PER_ASSIGNMENT_BUDGET_VALUES_F
2837:
2838: PARAMETERS
2839: p_assignment_id - The current assignment

Line 2893: from per_spinal_point_placements_f spp

2889: -- Check to see if a grade step has been created for assignment
2890: --
2891: cursor csr_grade_step is
2892: select spp.placement_id
2893: from per_spinal_point_placements_f spp
2894: where spp.assignment_id = p_assignment_id
2895: and p_val_st_date between spp.effective_start_date
2896: and spp.effective_end_date;
2897: --

Line 2902: from per_spinal_point_placements_f spp1

2898: -- Checks to see if future rows exist - Datetrack mode
2899: --
2900: cursor csr_future_records is
2901: select spp1.placement_id
2902: from per_spinal_point_placements_f spp1
2903: where spp1.assignment_id = p_assignment_id
2904: and spp1.effective_start_date > p_val_st_date;
2905: --
2906: -- Check to see if future records are for current parent spine

Line 2911: from per_spinal_point_placements_f spp2

2907: -- If so flag a warning!
2908: --
2909: cursor csr_record_check is
2910: select spp2.placement_id
2911: from per_spinal_point_placements_f spp2
2912: where spp2.assignment_id = p_assignment_id
2913: and spp2.effective_start_date > p_val_st_date
2914: and spp2.parent_spine_id = l_old_parent_spine_id
2915: and spp2.effective_end_date <= p_val_end_date;

Line 2924: from per_spinal_point_placements_f spp

2920: cursor csr_spp_rec(p_new_date date) is
2921: select spp.effective_end_date,
2922: spp.placement_id,
2923: spp.object_version_number
2924: from per_spinal_point_placements_f spp
2925: where spp.assignment_id = p_assignment_id
2926: and p_new_date between spp.effective_start_date
2927: and spp.effective_end_date;
2928: --

Line 2933: from per_spinal_point_placements_f spp

2929: -- Cursor to retrive the SPP effective_end_date
2930: --
2931: cursor csr_spp_end_date(p_placement_id number, l_edate date) is
2932: select spp.effective_end_date
2933: from per_spinal_point_placements_f spp
2934: where spp.placement_id = p_placement_id
2935: and l_edate between spp.effective_start_date
2936: and spp.effective_end_date;
2937: -- End of 3280773

Line 2954: FROM PER_SPINAL_POINT_PLACEMENTS_F P

2950: into p_del_flag
2951: FROM SYS.DUAL
2952: WHERE EXISTS
2953: (SELECT NULL
2954: FROM PER_SPINAL_POINT_PLACEMENTS_F P
2955: WHERE P.ASSIGNMENT_ID = p_assignment_id
2956: AND (p_mode = 'ZAP'
2957: OR (p_mode = 'END'
2958: AND EFFECTIVE_END_DATE > p_end_date)

Line 2985: from per_spinal_point_placements_f

2981: -- Get the min start date for the placement
2982: --
2983: select min(effective_start_date)
2984: into l_min_start_date
2985: from per_spinal_point_placements_f
2986: where assignment_id = p_assignment_id;
2987:
2988: if l_min_start_date = p_val_st_date
2989: and p_datetrack_mode = 'DELETE_NEXT_CHANGE' then

Line 3032: /* DELETE FROM PER_SPINAL_POINT_PLACEMENTS_F P

3028:
3029: --
3030: -- Removed dml and inserted call to api
3031: --
3032: /* DELETE FROM PER_SPINAL_POINT_PLACEMENTS_F P
3033: WHERE P.ASSIGNMENT_ID = p_assignment_id;
3034: */
3035: --
3036: ELSIF p_mode = 'FUTURE' THEN

Line 3062: from per_spinal_point_placements_f spp

3058: -- the current record as of the effective date
3059: --
3060: select spp.placement_id,spp.object_version_number,spp.effective_start_date,spp.parent_spine_id
3061: into l_placement_id,l_object_version_number,l_date_temp,l_old_parent_spine_id
3062: from per_spinal_point_placements_f spp
3063: where spp.assignment_id = p_assignment_id
3064: and p_val_st_date between spp.effective_start_date
3065: and spp.effective_end_date;
3066:

Line 3224: DELETE FROM PER_SPINAL_POINT_PLACEMENTS_F P

3220: --
3221: -- Removed dml and inserted call to api
3222: --
3223: /*
3224: DELETE FROM PER_SPINAL_POINT_PLACEMENTS_F P
3225: WHERE P.ASSIGNMENT_ID = p_assignment_id
3226: AND P.EFFECTIVE_START_DATE >= p_end_date
3227: AND NOT EXISTS
3228: (SELECT NULL

Line 3245: DELETE FROM PER_SPINAL_POINT_PLACEMENTS_F P

3241: --
3242: -- Removed dml and using api
3243: --
3244: /*
3245: DELETE FROM PER_SPINAL_POINT_PLACEMENTS_F P
3246: WHERE P.ASSIGNMENT_ID = p_assignment_id
3247: AND P.EFFECTIVE_START_DATE > p_end_date;
3248: */
3249:

Line 3259: from per_spinal_point_placements_f spp

3255: if csr_grade_step%found then
3256:
3257: select spp.placement_id,spp.object_version_number,spp.effective_start_date
3258: into l_placement_id,l_object_version_number,l_date_temp
3259: from per_spinal_point_placements_f spp
3260: where spp.assignment_id = p_assignment_id
3261: and p_end_date between spp.effective_start_date
3262: and spp.effective_end_date;
3263:

Line 3282: UPDATE PER_SPINAL_POINT_PLACEMENTS_F

3278: close csr_grade_step;
3279:
3280:
3281: /*hr_utility.set_location('hr_assignment.delete_ass_ref_int',5);
3282: UPDATE PER_SPINAL_POINT_PLACEMENTS_F
3283: SET EFFECTIVE_END_DATE = p_end_date
3284: , LAST_UPDATED_BY = p_last_updated_by
3285: , LAST_UPDATE_LOGIN = p_last_update_login
3286: , LAST_UPDATE_DATE = sysdate