95: CURSOR c_get_shift_diffs IS
96: SELECT DISTINCT
97: sdp.id
98: , sdp.name
99: FROM hxt_shift_diff_policies sdp;
100: --
101: -- cursor to get all Additional Assignment Info.
102: --
103: CURSOR c_get_add_ass_info IS
116: , nvl(hdp.business_group_id,-1) hdp_bg
117: FROM hxt_add_assign_info_f aai
118: , hxt_rotation_plans rpl
119: , hxt_earning_policies epg
120: , hxt_shift_diff_policies sdp
121: , hxt_hour_deduct_policies hdp
122: , per_assignments_f ass
123: WHERE aai.assignment_id = ass.assignment_id
124: AND aai.rotation_plan = rpl.id (+)