APPS.AHL_MC_APPROVALS_PVT dependencies on AHL_MC_HEADERS_B

Line 8: FROM ahl_mc_headers_b

4: -- Define cursor to check MC with particular mc_header_id, object_version_number exists
5: CURSOR check_mc_exists(p_mc_header_id in number, p_object_version_number in number)
6: IS
7: SELECT mc_header_id, name
8: FROM ahl_mc_headers_b
9: WHERE mc_header_id = p_mc_header_id and
10: object_version_number = nvl(p_object_version_number, object_version_number);
11:
12: PROCEDURE SET_ACTIVITY_DETAILS

Line 1636: UPDATE ahl_mc_headers_b

1632: RAISE FND_API.G_EXC_ERROR;
1633: END IF;
1634: CLOSE check_mc_exists;
1635:
1636: UPDATE ahl_mc_headers_b
1637: SET config_status_code = l_next_status,
1638: object_version_number = l_object_version_number + 1,
1639: last_update_date = sysdate,
1640: last_updated_by = to_number(fnd_global.login_id),

Line 1828: UPDATE ahl_mc_headers_b

1824: RAISE FND_API.G_EXC_ERROR;
1825: END IF;
1826: CLOSE check_mc_exists;
1827:
1828: UPDATE ahl_mc_headers_b
1829: SET config_status_code = l_next_status,
1830: object_version_number = l_object_version_number + 1,
1831: last_update_date = sysdate,
1832: last_updated_by = to_number(fnd_global.login_id),