APPS.HXT_CHK_BG_AND_UPGRADE_PKG dependencies on PER_ASSIGNMENTS_F

Line 122: , per_assignments_f ass

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 (+)
125: AND aai.earning_policy = epg.id
126: AND aai.shift_differential_policy = sdp.id (+)

Line 702: , per_assignments_f ass

698: and pet.business_group_id is not null
699: union
700: select distinct(ass.business_group_id) bg
701: from hxt_sum_hours_worked_f shw
702: , per_assignments_f ass
703: where shw.tim_id = p_tim_id
704: and shw.assignment_id = ass.assignment_id;
705: --
706: l_count number := 0;

Line 746: , per_assignments_f ass

742: and pet.business_group_id is not null
743: union
744: select distinct(ass.business_group_id) bg
745: from hxt_det_hours_worked_f dhw
746: , per_assignments_f ass
747: where dhw.tim_id = p_tim_id
748: and dhw.assignment_id = ass.assignment_id;
749: --
750: l_count number := 0;

Line 969: from per_assignments_f ass

965: from hxt_rotation_schedules
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

Line 1016: from per_assignments_f ass

1012: where sub.tws_id = p_wp_id);
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

Line 1067: , per_assignments_f ass

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;
1071: --

Line 1558: , per_assignments_f ass

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
1562: group by hep.id;

Line 1580: , per_assignments_f ass

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: --
1584: CURSOR c_get_egt_bg(p_id number) is

Line 1709: , per_assignments_f ass

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;
1713: --