APPS.HXT_CHK_BG_AND_UPGRADE_PKG dependencies on HXT_ADD_ASSIGN_INFO_F

Line 117: FROM hxt_add_assign_info_f aai

113: , nvl(epg.business_group_id,-1) ep_bg
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

Line 970: , hxt_add_assign_info_f aai

966: group by tws_id) rp_sub
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

Line 1017: , hxt_add_assign_info_f aai

1013: --
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

Line 1066: from hxt_add_assign_info_f aai

1062: select aai.id id
1063: , aai.assignment_id ass_id
1064: , aai.effective_start_date esd
1065: , aai.effective_end_date eed
1066: from hxt_add_assign_info_f aai
1067: , per_assignments_f ass
1068: where ass.business_group_id = p_bg
1069: and ass.assignment_id = aai.assignment_id
1070: and aai.rotation_plan = p_old_id;

Line 1082: update hxt_add_assign_info_f

1078: l_ass_id := assign.ass_id;
1079: l_aai_esd := assign.esd;
1080: l_aai_eed := assign.eed;
1081: --
1082: update hxt_add_assign_info_f
1083: set rotation_plan = l_new_id
1084: where id = l_aai_id
1085: and effective_start_date = l_aai_esd
1086: and effective_end_date = l_aai_eed;

Line 1557: , hxt_add_assign_info_f aai

1553: select distinct
1554: hep.id ep_id
1555: , count(distinct(ass.business_group_id)) count_bg
1556: from hxt_earning_policies hep
1557: , hxt_add_assign_info_f aai
1558: , per_assignments_f ass
1559: where hep.id = aai.earning_policy
1560: and aai.assignment_id = ass.assignment_id
1561: and hep.business_group_id is null

Line 1573: from hxt_add_assign_info_f aai

1569: , hep.egt_id egt_id
1570: from hxt_earning_policies hep
1571: where hep.business_group_id is null
1572: and not exists(select 'X'
1573: from hxt_add_assign_info_f aai
1574: where aai.earning_policy = hep.id);
1575: --
1576: CURSOR c_get_ass_bg(p_id number) is
1577: select distinct

Line 1579: from hxt_add_assign_info_f aai

1575: --
1576: CURSOR c_get_ass_bg(p_id number) is
1577: select distinct
1578: ass.business_group_id bg_id
1579: from hxt_add_assign_info_f aai
1580: , per_assignments_f ass
1581: where aai.assignment_id = ass.assignment_id
1582: and aai.earning_policy = p_id;
1583: --

Line 1708: from hxt_add_assign_info_f aai

1704: select aai.id id
1705: , aai.assignment_id ass_id
1706: , aai.effective_start_date esd
1707: , aai.effective_end_date eed
1708: from hxt_add_assign_info_f aai
1709: , per_assignments_f ass
1710: where ass.business_group_id = p_bg
1711: and ass.assignment_id = aai.assignment_id
1712: and aai.earning_policy = p_old_id;

Line 1724: update hxt_add_assign_info_f

1720: l_ass_id := assign.ass_id;
1721: l_aai_esd := assign.esd;
1722: l_aai_eed := assign.eed;
1723: --
1724: update hxt_add_assign_info_f
1725: set earning_policy = l_new_id
1726: where id = l_aai_id
1727: and effective_start_date = l_aai_esd
1728: and effective_end_date = l_aai_eed;