[Home] [Help]
42: CURSOR c_get_rotation_plans IS
43: SELECT DISTINCT
44: rtp.id
45: , rtp.name
46: from hxt_rotation_plans rtp;
47: --
48: -- cursor to get all Earning Groups.
49: --
50: CURSOR c_get_earn_groups IS
114: , aai.shift_differential_policy sdp_id
115: , ass.business_group_id ass_bg
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
967: , (select rts.tws_id wp_id
968: , count(distinct(ass.business_group_id)) ass_count
969: from per_assignments_f ass
970: , hxt_add_assign_info_f aai
971: , hxt_rotation_plans rtp
972: , hxt_rotation_schedules rts
973: where ass.assignment_id = aai.assignment_id
974: and aai.rotation_plan = rtp.id
975: and rtp.id = rts.rtp_id
1014: CURSOR c_get_ass_bg(p_wp_id number) is
1015: select distinct(ass.business_group_id) ass_bg
1016: from per_assignments_f ass
1017: , hxt_add_assign_info_f aai
1018: , hxt_rotation_plans rtp
1019: , hxt_rotation_schedules rts
1020: where ass.assignment_id = aai.assignment_id
1021: and aai.rotation_plan = rtp.id
1022: and rtp.id = rts.rtp_id
1272: , rtp.name
1273: , rtp.date_from
1274: , rtp.description
1275: , rtp.date_to
1276: from hxt_rotation_plans rtp
1277: , hxt_rotation_schedules rts
1278: where rtp.id = rts.rtp_id
1279: and rts.tws_id = p_wp_id;
1280: --
1303: open c_seqno;
1304: fetch c_seqno into l_rp_id;
1305: close c_seqno;
1306: --
1307: Insert into hxt_rotation_plans
1308: ( id
1309: , name
1310: , date_from
1311: , description
1448: where rtp_id = l_delete_rp(i);
1449: end loop;
1450: --
1451: For i in 1..l_rp_counter loop
1452: delete from hxt_rotation_plans
1453: where id = l_delete_rp(i);
1454: end loop;
1455: --
1456: delete from hxt_work_shifts