APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_TEMP_UNIT_SR_DEFERRALS

Line 1760: FROM ahl_temp_unit_SR_deferrals

1756: orig_mr_header_id,
1757: orig_unit_effectivity_id,
1758: group_match_flag,
1759: counter_id
1760: FROM ahl_temp_unit_SR_deferrals
1761: WHERE orig_unit_effectivity_id IS NULL
1762: FOR UPDATE OF unit_effectivity_id;
1763:
1764: -- Read group from ahl_ue_relationships.

Line 1786: FROM ahl_temp_unit_SR_deferrals

1782: orig_csi_item_instance_id,
1783: orig_mr_header_id,
1784: tolerance_flag,
1785: message_code
1786: FROM ahl_temp_unit_SR_deferrals
1787: START WITH parent_csi_item_instance_id = p_csi_item_instance_id
1788: AND parent_mr_header_id = p_mr_header_id
1789: AND orig_csi_item_instance_id = p_csi_item_instance_id
1790: AND orig_mr_header_id = p_mr_header_id

Line 1808: FROM ahl_temp_unit_SR_deferrals

1804: p_orig_csi_item_instance_id IN NUMBER,
1805: p_orig_mr_header_id IN NUMBER,
1806: p_unit_effectivity_id NUMBER) IS
1807: SELECT unit_effectivity_id
1808: FROM ahl_temp_unit_SR_deferrals
1809: WHERE csi_item_instance_id = p_parent_csi_item_instance_id
1810: AND MR_header_id = p_parent_mr_header_id
1811: AND orig_csi_item_instance_id = p_orig_csi_item_instance_id
1812: AND orig_mr_header_id = p_orig_mr_header_id

Line 2194: UPDATE ahl_temp_unit_SR_deferrals

2190:
2191: l_new_top_ue_id := l_unit_effectivity_id;
2192:
2193: -- update new UE ID for top node.
2194: UPDATE ahl_temp_unit_SR_deferrals
2195: SET unit_effectivity_id = l_new_top_ue_id,
2196: object_type = l_unit_effectivity_rec.object_type
2197: WHERE CURRENT OF ahl_unit_sr_def_csr ;
2198:

Line 2280: UPDATE ahl_temp_unit_SR_deferrals

2276: X_LAST_UPDATE_DATE => sysdate,
2277: X_LAST_UPDATED_BY => fnd_global.user_id,
2278: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
2279:
2280: UPDATE ahl_temp_unit_SR_deferrals
2281: SET unit_effectivity_id = l_unit_effectivity_id,
2282: object_type = l_unit_effectivity_rec.object_type
2283: WHERE CURRENT OF ahl_temp_csr ;
2284: